17,086
社区成员
发帖
与我相关
我的任务
分享
DECLARE
V_SQL VARCHAR(200);
BEGIN
SELECT LISTAGG(COLUMN_NAME,',') WITHIN GROUP (ORDER BY COLUMN_ID) INTO V_SQL FROM DBA_TAB_COLUMNS WHERE TABLE_NAME='T2' AND COLUMN_NAME NOT IN('NAME');
V_SQL:='SELECT '|| V_SQL || ' FROM T2 ';
DBMS_OUTPUT.PUT_LINE(V_SQL);
--EXECUTE IMMEDIATE V_SQL;
END;