Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Using the DBA_TAB_COLUMNS View

SQL> SQL> -- SQL> SQL> select column_name,data_type, nullable from dba_tab_columns   2  where rownum < 50; COLUMN_NAME ------------------------------ DATA_TYPE -------------------------------------------------- N - SPARE6 DATE Y SPARE5 VARCHAR2 Y SPARE4 VARCHAR2 Y SPARE3 NUMBER Y SPARE2 NUMBER Y SPARE1 NUMBER Y INTCOL# NUMBER N OFFSET NUMBER N SEGCOLLENGTH NUMBER COLUMN_NAME ------------------------------ DATA_TYPE -------------------------------------------------- N - N SEGCOL# NUMBER N POS# NUMBER N COL# NUMBER N BO# NUMBER N OBJ# NUMBER N SPARE6 DATE Y SPARE5 VARCHAR2 Y SPARE4 VARCHAR2 Y SPARE3 NUMBER Y SPARE2 NUMBER Y SPARE1 NUMBER Y CON# NUMBER N NAME VARCHAR2 N OWNER# NUMBER N SPARE6 DATE Y SPARE5 VARCHAR2 Y SPARE4 VARCHAR2 Y SPARE3 NUMBER Y SPARE2 NUMBER Y SPARE1 NUMBER Y FLAGS NUMBER Y OPTIMAL NUMBER Y KEEP NUMBER Y UGRP# NUMBER Y TS# NUMBER Y STATUS$ NUMBER N INST# NUMBER Y UNDOSQN NUMBER Y XACTSQN NUMBER Y SCNWRP NUMBER Y SCNBAS NUMBER Y BLOCK# NUMBER N FILE# NUMBER N USER# NUMBER N NAME VARCHAR2 N US# NUMBER N OBJ# NUMBER Y ROLE# NUMBER N PROXY# NUMBER N CLIENT# NUMBER N 49 rows selected.