System Tables Compatible with Oracle
The system tables CAT
and DUAL
are implemented in order to provide Oracle-related functionality. The tables are placed in the system schema SYS
.
The system schemas SYS
and EXA_STATISTICS
are automatically integrated into the namespace. This means that the tables in the system schemas can be accessed without specifying the schema as long as the same table name is not in use in the current schema.
CAT
This system table lists all of the tables and views in the current schema that the current user can access.
CAT
is not completely compatible with Oracle, since in Oracle this system table contains only objects that are owned by the user.
All users have access.
Column | Meaning |
---|---|
TABLE_NAME
|
Name of the table or the view |
TABLE_TYPE
|
Type of object: TABLE or VIEW |
DUAL
Along the lines of Oracle's identically named system table, this system table can be used to output static information
(for example,. SELECT CURRENT_USER FROM DUAL
). It contains one row with one single column.
All users have access.
Column | Meaning |
---|---|
DUMMY
|
Contains a NULL value |