select column_name from dba_tab_columns where table_name='你的大写表名';
SELECT OWNER||'.'||table_name From SYS.DBA_TABLES 这是取表名 SELECT OWNER,TABLE_NAME,COLUMN_NAME FROM DBA_TAB_COLUMNS 这是取列
查询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 OWNER,TABLE_NAME,COLUMN_NAME FROM 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"
;