虚谷数据库根据表名查询表结构数据sql

oracle版：

select COLUMN_NAME as "columnName",DATA_TYPE as "dataType" from user_tab_columns where table_name = #{tableName}

mysql版：

select column_name columnName, data_type dataType, column_comment columnComment, column_key columnKey, extra ,is_nullable as isNullable,column_type as columnType from information_schema.columns where table_name = #{tableName} and table_schema = (select database()) order by ordinal_position

虚谷版：

select * from dba_columns where table_id = (select table_id from dba_tables where table_name = #{tableName});