Question: HOW CAN SOLVE THE ERROR IN INSERT STATMENT CREATE TABLE T_ORDER_DATE AS( SELECT DISTINCT TO_CHAR (ORDER_DATE, 'DD-MM-YYYY') ORDER_DATE FROM OE.ORDERS) --7 CREATE TABLE T_DATE (ORDER_DATE

HOW CAN SOLVE THE ERROR IN INSERT STATMENT CREATE TABLE T_ORDER_DATE

HOW CAN SOLVE THE ERROR IN INSERT STATMENT

CREATE TABLE T_ORDER_DATE AS( SELECT DISTINCT TO_CHAR (ORDER_DATE, 'DD-MM-YYYY') ORDER_DATE FROM OE.ORDERS) --7 CREATE TABLE T_DATE (ORDER_DATE DATE, Day_No NUMBER (2), Day_Name CHAR(10), Month_NO NUMBER(2), Month_Name CHAR(10), Quarter NUMBER(1), YYear NUMBER (4)) 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 --8 INSERT INTO T_DATE (Day_No, Day_Name, Month_NO, Month_Name, Quarter, YYear) SELECT ORDER_DATE, TO_NUMBER (TO_CHAR (ORDER_DATE, 'DD')), TO_CHAR (ORDER_DATE, 'DAY'), TO_NUMBER (TO_CHAR (ORDER_DATE, 'MM')), TO_CHAR (ORDER_DATE, 'MONTH'), TO_CHAR (ORDER_DATE, 'Q'), TO_NUMBER (TO_CHAR (ORDER_DATE, 'YYYY')) FROM T_ORDER_DATE ;||

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!

helpe to complet the steps from 8 , with SQL code, the solve of first 7 steps : Command from 1 to 7 1- CREATE TABLE T_ORDER_DATE AS SELECT TO_CHAR ( ORDER_DATE , 'DD-MM-YYYY' ) AS ORDER_DATE FROM...

USING SQL I ANSWERED THE FIRST 4 AND I NEED WITH THE REST FROM 5-9 1. CREATE TABLE T_ORDER_DATE AS (SELECT ORDER_DATE FROM OE.ORDERS); We use CREATE TABLE ... AS statement to create a new table...

I need this in SQL, please. this is the DW example. -- CUSTOMERS_COPY CREATE TABLE CUSTOMERS_COPY AS SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT,...

WHATS WRONG IN INSERT STATMENT ORACEL LIVE CREATE TABLE T_ORDER_DATE AS( SELECT DISTINCT TO_CHAR (ORDER_DATE, 'DD-MM-YYYY') ORDER_DATE FROM OE.ORDERS) 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27...

Please use PL/SQL please need it so fast I will post the second part of the question CCDS-221 Data Warehouse Answer the following questions 1. Use the CREATE and SELECT statements to create...

USING SQL Answer the following questions 1. Use the CREATE and SELECT statements to create one-column temporary table T_ORDER_DATE (ORDER_DATE DATE) containing ORDER_DATE values (formatted as...

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),...

1) Use the CREATE and SELECT statements to create one-column temporary table called T_ORDER_DATE (ORDER_DATE DATE) by copying the ORDER_DATE values from the ORDERS table. (2 marks) 2) The T...

answer Q3,4,5 1) Use the CREATE and SELECT statements to create one-column temporary table called T_ORDER_DATE (ORDER_DATE DATE) by copying the ORDER_DATE values from the ORDERS table. (2 marks) 2)...

1. Evaluate this SQL statement: SELECT manufacturer_id, COUNT(*), order_date FROM inventory WHERE price > 5.00 GROUP BY order_date, manufactured_id HAVING COUNT(*) > 10 ORDER BY order_date DESC;...

Consider a U. S. firm that has for many years exported to European countries. How does the creation of the euro simplify or complicate the management of transactions exposure for this firm?

True or false owners of firms with less than 1 0 0 people usually handle HR task

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How many Tables Will Base HCMSs typically have? Why?

What is the process of normalization?

What is Notation in Data Modeling, and what is the most common Notation Type used?