꿈라CBT다음 테이블에 데이터를 입력할 때 자료형 오류가 발생하는 문장은?
보기
CREATE TABLE EVENT_LOG (
EVENT_NO NUMBER,
EVENT_NM VARCHAR2(10),
EVENT_DT DATE
);- 1
INSERT INTO EVENT_LOG VALUES (10, 'OPEN', DATE '2025-01-15'); - 2
INSERT INTO EVENT_LOG VALUES (10, 'OPEN', TO_DATE('20250115', 'YYYYMMDD')); - 3
INSERT INTO EVENT_LOG VALUES (10, 'OPEN', 20250115); - 4
INSERT INTO EVENT_LOG VALUES (10, 'OPEN', TRUNC(SYSDATE));