数据表字段拼接

ORACLE:

SELECT T.COLUMN_NAME,'A.' || T.COLUMN_NAME || ',' FROM USER_COL_COMMENTS T WHERE T.TABLE_NAME = UPPER('TABLE_NAME');

posted @ 2020-08-13 17:07  Journey&Flower  阅读(225)  评论(0编辑  收藏  举报