更多资料 查询
https://www.cnblogs.com/kongxc/p/9395148.html
获取表字段:
select *
from user_tab_columns
where Table_Name='用户表'
order by column_name
select * from user_tab_columns where Table_Name='ACCOUNT_BM' order by COLUMN_ID
可以获取某个字段
select TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH
from user_tab_columns
where Table_Name='ACCOUNT_BM'
order by COLUMN_ID