USER_TAB_COLUMNS
如:可以查询某些特殊列的数量等,很有用
SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'TRN_QUOTES_5127' AND COLUMN_NAME LIKE 'PURCHASED_QTY%';
USER_TAB_COLUMNS
如:可以查询某些特殊列的数量等,很有用
SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'TRN_QUOTES_5127' AND COLUMN_NAME LIKE 'PURCHASED_QTY%';