//--查询字段的注释 注意owner,tablename名要大写!
SELECT * FROM Dba_Col_Comments WHERE OWNER='QZUSER' AND TABLE_NAME='DEPT'
//查询表结构
select column_name,data_type
from DBA_TAB_COLS
where OWNER='QZUSER' and TABLE_NAME='DEPT'
//--查询字段的注释 注意owner,tablename名要大写!
SELECT * FROM Dba_Col_Comments WHERE OWNER='QZUSER' AND TABLE_NAME='DEPT'
//查询表结构
select column_name,data_type
from DBA_TAB_COLS
where OWNER='QZUSER' and TABLE_NAME='DEPT'