–第一种方法: 查询dba_tab_columns 代码如下: select COLUMN_NAME,DATA_TYPE,DATA_LENGTH from dba_tab_columns where table_name =upper(‘表名’) order by COLUMN_NAME –这种方法需要有DBA权限 –第二种方法: 查询user_tab_cols select COLUMN_NAME,DATA_TYPE,DATA_LENGTH from user_tab_cols where table_name=upper(‘表名’) order by COLUMN_NAME –这种方法只
