SELECT
A.column_name AS "字段名",
A.data_type AS "类型",
A.char_length AS "长度" ,
B.comments AS "描述"
FROM sys.all_tab_columns A,
sys.dba_col_comments B
WHERE A.owner = B.owner
AND A.table_name = B.table_name
AND A.column_name = B.column_name
AND A.table_name= 'T_CPS_DEV_ELE_ENERGY_METER'
ORDER BY A.table_name ;
获取oracle 数据库字典
最新推荐文章于 2023-06-02 14:59:36 发布