오라클 PL-SQL 스크립트 뽑아내기
SELECT name
, case rk
when 1 then CHR(10) ||CHR(10) ||'/'||CHR(10) ||CHR(10) ||'CREATE OR REPLACE '||text
else text
end AS text
FROM (SELECT name
, RANK () OVER (PARTITION BY name
ORDER BY rownum) rk
,text
FROM user_source
WHERE type like 'FUNC%' )
, case rk
when 1 then CHR(10) ||CHR(10) ||'/'||CHR(10) ||CHR(10) ||'CREATE OR REPLACE '||text
else text
end AS text
FROM (SELECT name
, RANK () OVER (PARTITION BY name
ORDER BY rownum) rk
,text
FROM user_source
WHERE type like 'FUNC%' )