abhi1010

SELECT
column_name "Name",
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='ASGDLX_TBLBRAND'

where "ASGDLX_TBLBRAND" is the table name.