Question: Please use PL/SQL please i need it so fast this is the second part of the question CCDS-221 Data Warehouse Note. All extracted values for

Please use PL/SQL
please i need it so fast
this is the second part of the question
CCDS-221 Data Warehouse Note. All extracted values for CHAR fields (Day_Name and Month_Name) must be directly obtained in CAPITAL letters to avoid converting them in a further step. The syntax of the CHAR function is: Syntax: TO_CHAR( Date_value, 'format_mask' ) where the format_mask uses the following: Explanation Symbol YYYY 4-digit year YYY YY Y Last 3, 2, or i digit(s) of year. Q MM MON or Mon Quarter of year (1, 2, 3, 4; JAN-MAR = 1). Month (01-12; JAN = 01). Abbreviated name of month in UPPERCASE or First letter in upper. Name of month, padded with blanks to length of 9 characters. Day of week (1-7). MONTH D Name of day in upper (DAY) or First letter upper (Day). DAY or Day DD Day of month (1-31). Day of year (1-366). DDD 9. Display the content of the T_DATE table (Now, you can DROP T_ORDER_DATE). Adding a Primary column to T_DATE. So far, T_DATE does not have a primary key. You will add a Primary key column to T_DATE. To do so, answer the questions below. 10. Re CREATE T_DATE with a new column ID_DATE NUMBER (5) as a first column (before all others). 11. Define a PK constraint PK_ID_DATE on the new column ID_DATE. 12. CREATE an Oracle Sequence SEQ_ID_DATE starting with 10000 to generate sequential identifiers for the PK column (PK_ID_DATE). 13. Improve your answer to question 8 so that it inserts the rows with PK values. 14. Display the new content of T_DATE. 15. Save your session as Lab6.sql, download and clean the script file you will need it later
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
