Question: Q2) Use pl/sql code to execute the following: (i) Create a table CUSTOMER with the following columns:- CUSTID CUSTNAME ITEMS PRICE 2012 LINA LAPTOP 15000
Q2) Use pl/sql code to execute the following: (i) Create a table CUSTOMER with the following columns:- CUSTID CUSTNAME ITEMS PRICE 2012 LINA LAPTOP 15000 2015 REEM MOBILE 20000 2018 SAM BOOKS 12000 2020 TOM BAGS 5000 a) Insert 4 records into table CUTOMER using pl/sql code. b) Display the table after performing insert operation. c) Display the PRICE of the ITEMS where CUSTID=2012. d) Display the CUSTID ,CUSTNAME where ITEMS=MOBILE. e) Display the count of number of ITEMS. (ii) Create a table CUSTLOG with variables-CODEID, CODEMSG. Write pl/sql code to check if PRICE >=5000 ,display the comment-ALL ITEMS AVAILABLE" and Insert this comment and data into the CUSTLOG table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
