SELECT * FROM user_tab_columns WHERE TABLE_NAME='表名'; 表名区分大小写的!
select t.column_name, decode(t.data_type,'NUMBER','NUMBER('||to_char(t.data_precision)||','||to_char(t.data_scale)||')', 'DATE','DATE', 'CHAR','CHAR('||to_char(a.data_length)||')', 'VARCHAR2','VARCHAR2('||to_char(a.data_length)||')', ... ... from user_tab_cols t where t.table_name = 'TABLENAME';
select t.column_name, decode(t.data_type,'NUMBER','NUMBER('||to_char(t.data_precision)||','||to_char(t.data_scale)||')', 'DATE','DATE', 'CHAR','CHAR('||to_char(t.data_length)||')', 'VARCHAR2','VARCHAR2('||to_char(t.data_length)||')', ... ... from user_tab_cols t where t.table_name = 'TABLENAME';
表名区分大小写的!
decode(t.data_type,'NUMBER','NUMBER('||to_char(t.data_precision)||','||to_char(t.data_scale)||')',
'DATE','DATE',
'CHAR','CHAR('||to_char(a.data_length)||')',
'VARCHAR2','VARCHAR2('||to_char(a.data_length)||')',
... ...
from user_tab_cols t where t.table_name = 'TABLENAME';
decode(t.data_type,'NUMBER','NUMBER('||to_char(t.data_precision)||','||to_char(t.data_scale)||')',
'DATE','DATE',
'CHAR','CHAR('||to_char(t.data_length)||')',
'VARCHAR2','VARCHAR2('||to_char(t.data_length)||')',
... ...
from user_tab_cols t where t.table_name = 'TABLENAME';
谢谢!我已经说了我不能从系统表获得。我希望能够从结果集中自动获取,因为我要实现一个通用的结果集显示功能。
也就是给你任何一个sql,你执行之后,把sql对应的查询结果自动显示在列表中。