Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

ALL_TAB_COLUMNS view contains information about the columns in all tables accessible

SQL> select column_name, data_type from all_tab_columns   2  where table_name = 'COUNTRIES'; COLUMN_NAME ------------------------------ DATA_TYPE -------------------------------------------------------------------------------- COUNTRY_ID CHAR COUNTRY_NAME VARCHAR2 REGION_ID NUMBER SQL>