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.