Oracle Data Dictionary Views
GPTKB entity
Statements (51)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Database View
|
| gptkbp:access |
SELECT statements
|
| gptkbp:accessibleBy |
Developers
Applications Database administrators |
| gptkbp:category |
All views
Base tables DBA views User views |
| gptkbp:contains |
Information about columns
Information about constraints Information about grants Information about indexes Information about privileges Information about procedures Information about roles Information about sequences Information about storage Information about synonyms Information about tables Information about triggers Information about users Information about views |
| gptkbp:documentation |
Oracle Database Reference Guide
|
| gptkbp:example |
ALL_CONSTRAINTS
ALL_INDEXES ALL_OBJECTS ALL_TABLES ALL_TAB_COLUMNS DBA_CONSTRAINTS DBA_INDEXES DBA_OBJECTS DBA_TABLES DBA_TAB_COLUMNS USER_CONSTRAINTS USER_INDEXES USER_OBJECTS USER_TABLES USER_TAB_COLUMNS |
| gptkbp:features |
Access controlled by privileges
|
| https://www.w3.org/2000/01/rdf-schema#label |
Oracle Data Dictionary Views
|
| gptkbp:namingConvention |
ALL_ prefix for all accessible objects
DBA_ prefix for all objects in the database USER_ prefix for current user |
| gptkbp:purpose |
Store metadata about database objects
Provide information about schema, users, tables, indexes, constraints, and more |
| gptkbp:readOnly |
Yes
|
| gptkbp:updated |
Oracle Database engine
|
| gptkbp:usedIn |
gptkb:Oracle_Database
|
| gptkbp:bfsParent |
gptkb:Flashback_Transaction_Query
|
| gptkbp:bfsLayer |
8
|