문제 링크 : https://velog.io/@yooha9621/SQLP실기문제-고급SQL활용59번
INSERT INTO ERRLOG
SELECT TO CHAR(SYSDATE, 'YYYYMMDDHH24') CH_DTH
, CASE WHEN ST01='E01' THEN 'E01'
WHEN ST02='E02' THEN 'E02'
WHEN ST03='E03' THEN 'E03'
WHEN ST04='E04' THEN 'E04'
WHEN ST05='E05' THEN 'E05'
WHEN ST06='E06' THEN 'E06'
WHEN ST07='E07' THEN 'E07'
WHEN ST08='E08' THEN 'E08'
WHEN ST09='E09' THEN 'E09'
WHEN ST10='E10' THEN 'E10'
END AS ERR_CD
, RNO
FROM RSTLOG ;
SQL>
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
INSERT INTO ERRLOG
SELECT
TO CHAR(SYSDATE, 'YYYYMMDDHH24') CH_DTH
, CASE WHEN ST01='E01' THEN 'E01'
WHEN ST02='E02' THEN 'E02'
WHEN ST03='E03' THEN 'E03'
WHEN ST04='E04' THEN 'E04'
WHEN ST05='E05' THEN 'E05'
WHEN ST06='E06' THEN 'E06'
WHEN ST07='E07' THEN 'E07'
WHEN ST08='E08' THEN 'E08'
WHEN ST09='E09' THEN 'E09'
WHEN ST10='E10' THEN 'E10'
END AS ERR_CD
, RNO
FROM RSTLOG
WHERE (
ST01 = 'A' OR
ST02 = 'B' OR
ST03 = 'C' OR
ST04 = 'D' OR
ST05 = 'E' OR
ST06 = 'F' OR
ST07 = 'G' OR
ST08 = 'H' OR
ST09 = 'I' OR
ST10 = 'J'
);
DELETE FROM RSTLOG;