cname2

select
column_id,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
from user_tab_columns
where table_name = ''
order by column_id;