Hi,
the describe option allows you to describe an object within a specific schema.
if you want to describe a particular column just perform:
select column_name,data_type,data_length,nullable from user_tab_columns
where table_name = 'EMP'
and column_name = 'ENAME';
you can put it in a procedure.




Reply With Quote