查询oracle表结构和注释

xiaoxiao2025-04-22  14

SELECT     A .COLUMN_NAME,     B.comments,     A .DATA_TYPE || '(' || A .DATA_LENGTH || ')' 类型 FROM     user_tab_columns A,     user_col_comments B WHERE     A .TABLE_NAME = B.table_name AND A .COLUMN_NAME = B.column_name AND A .Table_Name = 'RISK_INFORMATIONBASEM'

转载请注明原文地址: https://www.6miu.com/read-5028885.html

最新回复(0)