SQL> SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER='TKIENTZLE'; TABLE_NAME ----------------------------- CALENDAR SQL> SELECT COLUMN_NAME,DATA_TYPE FROM DBA_TAB_COLUMNS WHERE TABLE_NAME='CALENDAR'; COLUMN_NAME DATA_TYPE ---------- --------- CAL_DATE DATE CAL_DESCR VARCHAR2 CAL_OWNER VARCHAR2
Example 1: Querying basic database information in Oracle through the DBA_TABLES and DBA_TAB _ COLUMNS tables.