select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=表名];--------------说明:column_name:列名（varchar2(30)）;data_type:列的数据类型（varchar2(106)）;data_length:列的长度（number); ----------或者:select * from 表 where 11这样可以取得空数据表,循环取返回表的列名也可以....
