Question: 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

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

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

Step by Step Solution

3.51 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

After Updation of T... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!