AI智能
改变未来

Oracle导出表结构到excel

[code]SELECT a.COLUMN_NAME,a.DATA_TYPE,a.DATA_LENGTH,a.NULLABLE,b.COMMENTSfrom ALL_TAB_COLUMNS a,ALL_COL_COMMENTS bWHERE a.OWNER=b.OWNER AND a.TABLE_NAME=b.TABLE_NAME AND a.COLUMN_NAME=b.COLUMN_NAMEAND a.OWNER=\'LOANCORE\' AND a.TABLE_NAME=\'T_BA_REPAY_PLAN\'ORDER BY a.COLUMN_ID;

 

赞(0) 打赏
未经允许不得转载:爱站程序员基地 » Oracle导出表结构到excel