• 章节:25
  • 访问:594
  • 时长:00:03:03
  • 日期:2020-06-08 09:09

更多资料 查询

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