ALL_TAB_COLUMNS view contains information about the columns in all tables accessible : all_tab_columns « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. all_tab_columns

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>

   
    
  

Related examples in the same category