Question: Database to use. Use the 'Order Entry' (OE) Database schema available at the link https://livesql.oracle.com to answer. Note. The SELECT privilege is GRANTed to PUBLIC

Database to use. Use the 'Order Entry' (OE) Database schema available at the link https://livesql.oracle.com to answer. Note. The SELECT privilege is GRANTed to PUBLIC on the tables so that you prefix each table of this DB by its creator (OE) in SQL statements (You can also create a synonym). Before using the tables, display the content of CUSTOMERS, ORDERS and ORDER_ITEMS. A sample of the content of these tables is in Appendix 1. Answer the following questions. Using the NVL Function. 1. Use the CREATE and SELECT SQL statements to Create a Temporary table as a full copy (all rows & columns) of the table ORDERS. Name the new table ORDERS_COPY
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
