Question: 1. Create the following tables and insert given data's: CONSTRAINT TABLE NAME PRODUCTDB FIELD NAME DATA TYPE PRODUCT D NUMBER (5) PRODUCT_NAME VARCHAR2(20) SUPPLIER_NAME VARCHAR2(20)

1. Create the following tables and insert given data's: CONSTRAINT TABLE NAME PRODUCTDB FIELD NAME DATA TYPE PRODUCT D NUMBER (5) PRODUCT_NAME VARCHAR2(20) SUPPLIER_NAME VARCHAR2(20) UNIT PRICE NUMBER(12,3) PRIMARY KEY NOT NULL ACCEPT Validate UNIT_PRICE ONLY POSITIVE VALUE CONSTRAINT DATA TYPE NUMBER (5) PRIMARY KEY TABLE NAME ORDERDB FIELD NAME ORDER_ID ORDER_DATE CUSTOMER_NAME ORDER AMOUNT | PRODUCT_NO DATE NOT NULL VARCHAR2(20) NUMBER(12,3) NUMBER(5) FOREIGN KEY PRODUCTDB TABLE: PRODUCT ID PRODUCT_NAME 10001 DESKTOP 10002 LABTOP 10003 PRINTER SUPPLIER_NAME UNIT PRICE SONY 400.500 HAWLETT PACKARD 350.850 CANNON 75.500 ORDERDB TABLE: ORDER ID ORDER DATE CUSTOMER NAME 1 20-JAN-2018 SALALAH COLLEGE 2 20-FEB-2018 IBRA COLLEGE 3 15-MAR-2018 NIZWA COLLEGE 4 20-MAR-2018 SALALAH COLLEGE ORDER AMOUNT PRODUCT NO 9000.000 10002 5000.000 10003 1800 00 10001 5500.000 10003 Write SQL queries for the following 1. Display different types of customer_name from Order Table 2. Display total Order Amount for the customer whose customer name 'SALALAH COLLEGE 3. Display how many number of days from the Customer Order date as on System Date. 4. Display all product name whose product name is more than 6 character 5. Add one following Column in PRODUCT TABLE FIELD NAME PROD_MAKING DATE DATA TYPE DATE 6. Update Prod making Date as Current system date (Use NVL function) 7. Display all Order Date in the following format (eg Saturday. Twenty, January, Twenty Eighteen, 11 30:25 am)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
