Oracle快速生成表和字段sql

Oracle快速生成表和字段sql

SELECT CONCAT(CONCAT(CONCAT(CONCAT('COMMENT ON table ', TABLE_NAME), ' IS '''), COMMENTS), ''';') FROM user_tab_comments WHERE  TABLE_NAME = 'OT_ALIPAYTRANS'
UNION
SELECT CONCAT(
               CONCAT(
                       CONCAT(
                               CONCAT(
                                       CONCAT(
                                               CONCAT('comment on column ', TABLE_NAME )
                                           , '.')
                                   , COLUMN_NAME)
                           , ' IS ''')
                   , COMMENTS)
           ,''';' )
FROM user_col_comments WHERE TABLE_NAME = 'OT_ALIPAYTRANS'