SQL Query - Find columns of any table

The below query will fetch column details of and database table :

SELECT 

column_id,

column_name,

data_type,

data_length,

data_precision

FROM dba_tab_columns

WHERE table_name = 'PER_ALL_PEOPLE_F'  -- enter the table name

order by column_id

PREVIOUS POST || NEXT POST