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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!