Question: WHATS WRONG HERE 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

WHATS WRONG HERE
46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 CREATE TABLE T_DATE ( ID_DATE number(5), ORDER_DATE DATE, Day_No NUMBER(1), Day_Name CHAR(10), Month_NO NUMBER (2), Month_Name CHAR(10), Quarter NUMBER(1), YYear NUMBER (4) ); --11 ALTER TABLE T_DATE ADD CONSTRAINT PK_ID_DATE PRIMARY KEY(ID_DATE); --12 CREATE SEQUENCE SEQ_ID_DATE START WITH 10000 INCREMENT BY 1 --13 INSERT INTO T_DATE (ID_DATE, ORDER_DATE, Day_No, Day_Name, Month_NO, Month_Name, Quarter, YYear) SELECT SEQ_ID_DATE.nextval, ORDER_DATE, TO_CHAR (ORDER_DATE, 'DD'), TO_CHAR (ORDER_DATE, 'DAY'), TO_CHAR (ORDER_DATE, 'MM'), TO_CHAR (ORDER_DATE, MONTH'), TO_CHAR (ORDER_DATE, ''), TO_CHAR (ORDER_DATE, Y') FROM T_ORDER_DATE ; -- 14
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
