System Tables Compatible with Oracle

The following system tables are implemented in order to provide Oracle-related functionality.


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 because 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


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