Displaying table metadata (data about data)

To find the names of the tables that you have created, use the view called cat or tab in the SELECT statement.

SQL> select * from cat;

TABLE_NAME TABLE_TYPE
------------------------------ -----------
SAMPLE TABLE
TEST TABLE
CHILD TABLE
SEQ_TEST SEQUENCE
SEQSAMPLE TABLE
BIN$U6KfB5ApT1O9xKAFd9PnsA==$0 TABLE
BIN$0Mf6cwpmTnOXVUmXDBLnPA==$0 TABLE
TESTA TABLE
BIN$9iac65ZYQvOMzxudpHYijw==$0 TABLE
MYTEST TABLE

21 rows selected.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE
XYZ TABLE
TESTB TABLE
BIN$7E43RxQORwuc7tISq/SZVA==$0 TABLE
MYTAB TABLE
DIGITS TABLE
BIN$jwDk7ZM8TdO3TOBSmGrTeQ==$0 TABLE
MASTER TABLE

20 rows selected.



SQL> select interval '312' month,
interval '20-6' year to month,
interval '12:30:10.1234567' hour to second from dual;

INTERVAL'312'MONTH
-------------------------------------------------------------
INTERVAL'20-6'YEARTOMONTH
-------------------------------------------------------------
INTERVAL'12:30:10.1234567'HOURTOSECOND
-------------------------------------------------------------
+26-00
+20-06
+00 12:30:10.123457