Comments (1)
Actually, there is much more of such objects:
SQL> select object_name from dba_objects o where o.owner='SYS' and o.object_type='TYPE' and not exists (select 1 from dba_source s where s.owner='SYS' and s."TYPE"='TYPE' AND s."NAME"=o.object_name);
OBJECT_NAME
------------------------------
BFILE
BINARY ROWID
BINARY_DOUBLE
BINARY_FLOAT
BLOB
CANONICAL
CFILE
CHAR
CLOB
CONTIGUOUS ARRAY
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
INTEGER
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH
KOTAD
KOTADX
KOTMD
KOTMI
KOTTB
KOTTBX
KOTTD
LOB POINTER
NAMED COLLECTION
NAMED OBJECT
NUMBER
OCTET
OID
PL/SQL BINARY INTEGER
PL/SQL BOOLEAN
PL/SQL COLLECTION
PL/SQL LONG
PL/SQL LONG RAW
PL/SQL NATURAL
PL/SQL NATURALN
PL/SQL PLS INTEGER
PL/SQL POSITIVE
PL/SQL POSITIVEN
PL/SQL RECORD
PL/SQL REF CURSOR
PL/SQL ROWID
PL/SQL STRING
POINTER
RAW
REAL
REF
SIGNED BINARY INTEGER(16)
SIGNED BINARY INTEGER(32)
SIGNED BINARY INTEGER(8)
SMALLINT
TABLE
TIME
TIME WITH TZ
TIMESTAMP
TIMESTAMP WITH LOCAL TZ
TIMESTAMP WITH TZ
UNSIGNED BINARY INTEGER(16)
UNSIGNED BINARY INTEGER(32)
UNSIGNED BINARY INTEGER(8)
UROWID
VARCHAR
VARCHAR2
VARYING ARRAY
KOKED
KOKED1
67 rows selected.
from ddlfs.
Related Issues (13)
- File sizes HOT 4
- Obtain triggers/ from all_source
- Support for editionable objects HOT 1
- Test scripts HOT 1
- Support for external authentication HOT 1
- Make query "faster" when locally cached version already exist. HOT 1
- 4 kB read block HOT 6
- execution bit
- DBRO options need a DBA user
- dbro & execution bit HOT 1
- Windows? HOT 8
- Support for SYNONYM HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ddlfs.