Create a PL/SQL Stored Procedures to do the following tasks 1. Create a table named customers_697...

 

Transcribed Image Text:

Create a PL/SQL Stored Procedures to do the following tasks 1. Create a table named customers_697 and populate the table with data (modify the script provided with this assignment) Create the following record in the customers 697 table -Use Insert statement for this id name age Address salary (Last 4 digits of your student number) (Your Name) any (your city) Any (except 6000) (A). Now create a stored procedure to Update data in the table Name of the stored procedure is sp Updateflast4digitstudentid -Now Update your salary to 6000 using the stored procedure you created (pass your id or name) - Show updated record in the table Now create a stored procedure to Retrieve data from the table, Name of the stored procedure is sp Select/last4digitstudentid] - Retrieve your record by passing the id to the above stored procedure ane of the customes with depande vin caps Show all relevant Screens with source code in word format Explain the code block Create a PL/SQL Stored Procedures to do the following tasks 1. Create a table named customers_697 and populate the table with data (modify the script provided with this assignment) Create the following record in the customers 697 table -Use Insert statement for this id name age Address salary (Last 4 digits of your student number) (Your Name) any (your city) Any (except 6000) (A). Now create a stored procedure to Update data in the table Name of the stored procedure is sp Updateflast4digitstudentid -Now Update your salary to 6000 using the stored procedure you created (pass your id or name) - Show updated record in the table Now create a stored procedure to Retrieve data from the table, Name of the stored procedure is sp Select/last4digitstudentid] - Retrieve your record by passing the id to the above stored procedure ane of the customes with depande vin caps Show all relevant Screens with source code in word format Explain the code block