oracle 查看表结构和注释
oracle 查看表结构和注释SELECT T1.TABLE_NAME,T1.COLUMN_NAME,T1.DATA_TYPE || ‘(’ || T1.DATA_LENGTH || ‘)’,T2.COMMENTSFROM USER_TAB_COLS T1, USER_COL_COMMENTS T2WHERE T1.TABLE_NAME = T2.TABLE_NAMEAND T1.C...
原创
2020-09-16 17:41:06 ·
636 阅读 ·
0 评论