select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=表名];
其中:column_name:列名(varchar2(30)); data_type:列的數(shù)據(jù)類型(varchar2(106)); data_length:列的長度(number); eg:select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns where table_name='TEST_TEMP'; 結(jié)果:
-------------------------------------------------------------------------------- column_name data_type data_length data_precision data_scale ID NUMBER 22 0 NAME NVARCHAR2 20 SEX CHAR 1 GRADE NVARCHAR2 10