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); eg:select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns where table_name='TEST_TEMP'; 結果：
-------------------------------------------------------------------------------- column_name data_type data_length data_precision data_scale ID NUMBER 22 0 NAME NVARCHAR2 20 SEX CHAR 1 GRADE NVARCHAR2 10
