[Quote=引用 6 楼 weijiajia11 的回复:]
SELECT * FROM all_tab_cols WHERE owner = UPPER('hcsp_ai') AND table_name = UPPER('cr_ssi_cso_hp');
是对的,但是,排序是乱的,能跟数据一样的显示顺序吗?
[/Quote]
SELECT * FROM all_tab_cols WHERE owner = UPPER('hcsp_ai') AND table_name = UPPER('cr_ssi_cso_hp')
ORDER BY COLUMN_ID;
SELECT * FROM all_tab_cols WHERE owner = UPPER('hcsp_ai') AND table_name = UPPER('cr_ssi_cso_hp');
or
SELECT * FROM all_tab_columns WHERE owner = UPPER('hcsp_ai') AND table_name = UPPER('cr_ssi_cso_hp');