Ibatis怎么查询列名,有多少列提前不知道;
取得oracle中表的列名
关键字: oracle 查询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"
哈哈,变像解决了,mysql,sqlserver都相类似的系统表存储列名!
select name from syscolumns where id=object_id('dbo.table)
order by name desc