select table_name,tablespace_name,temporary from user_tables [where table_name=表名]
select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=表名];
select table_name,tablespace_name,temporary from user_tables [where table_name=表名]
select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=表名];