查询dba_tab_columns
如:
select column_name
from dba_tab_columns
where owner=upper('xxx')
and table_name=upper('yyy')
;
如果表名的区分大小写的话,注意表名用双引号,如:
select column_name
from dba_tab_columns
where owner=upper('xxx')
and table_name="MyTable"
;
如:
select column_name
from dba_tab_columns
where owner=upper('xxx')
and table_name=upper('yyy')
;
如果表名的区分大小写的话,注意表名用双引号,如:
select column_name
from dba_tab_columns
where owner=upper('xxx')
and table_name="MyTable"
;