desc tablename
select cname from col where tname='TABLENAME';
select column_name from user_tab_columns where table_name='TABLENAME';
select column_name from ALL_tab_columns where table_name='TABLENAME';
select column_name from dba_tab_columns where table_name='TABLENAME';
select cname from col where tname='TABLENAME';
select column_name from user_tab_columns where table_name='TABLENAME';
select column_name from ALL_tab_columns where table_name='TABLENAME';
select column_name from dba_tab_columns where table_name='TABLENAME';
select tname,cname,coltype,width,nulls from col where tname = 'TBNAME';
select cname,coltype,width from col where tname='TABLENAME';
select column_name,data_type,data_lengtyh from user_tab_columns where table_name='TABLENAME';
select column_name,data_type,data_lengtyh from ALL_tab_columns where table_name='TABLENAME';
select column_name,data_type,data_lengtyh from dba_tab_columns where table_name='TABLENAME';
还有一个与列有关
user_col_comment
select column_name from all_col_comments where table_name='TABLENAME';
select column_name from dba_col_comments where table_name='TABLENAME';
你可参考下面模拟create table语句的写法:
select decode(T1.column_id,1,'create table '||T1.table_name||'(',' ') A,
T1.coulmn_name B,
T1.data_type||decode(T1.data_type,'varchar2','('||to_char(T1.data_length) ||')','number','('||to_char(T1.data_precision)||','||to_char(T1.data_scale) ||')','char','('||to_char(T1.data_length)||')')||decode(T1.column_id,max (T2.column_id),')',';') C
from user_tab_column T1, user_tab_column T2
where T1.table_name = T2.table_name
and T1.table_name = 'your_table_name'
group by T1.column_id, T1.table_name, T1.data_type, T1.data_length, T1.data_scale, T1.column_name, T1.data_precision
order by T1.column_id;