Oracle快速生成表和字段sql
SELECT DISTINCT CONCAT(CONCAT('COMMENT ON table ', TABLE_NAME), ' IS '''';' ) FROM user_col_comments WHERE TABLE_NAME = 'BANKPRODUCTGROUP'
UNION
SELECT CONCAT(CONCAT(CONCAT(CONCAT('comment on column ', TABLE_NAME ), '.'), COLUMN_NAME), ' IS '''';' )FROM user_col_comments WHERE TABLE_NAME = 'BANKPRODUCTGROUP'