SELECT
'INSERT INTO' || ' IR_ONLINE_GDS_CLSF' || '(' || CC1 || ')VALUES(' || CC2 || ')'
FROM
(
SELECT
LISTAGG(COLUMN_NAMES) WITHIN
GROUP
(
ORDER BY
COLUMN_ID
) AS CC1,
LISTAGG(COL_VALUES) WITHIN
GROUP
(
ORDER BY
COLUMN_ID
) AS CC2
FROM
(
SELECT
TABLE_NAME,
COLUMN_ID,
'' || COLUMN_NAME || ',' COLUMN_NAMES,
'#{' || LOWER(SUBSTR(COLUMN_NAME, 1, 1)) || SUBSTR(REPLACE (INITCAP(LOWER(COLUMN_NAME)), '_', ''), 2) || '},' AS COL_VALUES
FROM
USER_TAB_COLS
WHERE
TABLE_NAME = UPPER('IR_ONLINE_GDS_CLSF')
)
);
'Programming' 카테고리의 다른 글
테드폴디비허브 데모서버[Tadpole DB Hub] (0) | 2023.05.24 |
---|---|
웹 페이지 로딩 과정 이해하기 (0) | 2023.05.24 |
Sql Tutorial (0) | 2023.05.14 |
Python Tutorial (0) | 2023.05.14 |
[오라클]오라클 전문가로 가는 지름길[예제파일] (0) | 2023.01.08 |