Database Programming PL/ SQL – Stored Procedures Create a PL/SQL Stored Procedures to do the following tasks (Script is
Posted: Thu Jul 14, 2022 2:06 pm
Database Programming
PL/ SQL – Stored Procedures
Create a PL/SQL Stored Procedures to dothe following tasks
(Script is provided with thisassignment)
1. Create a table named customers_697and populate the table with data (use the script provided withthis assignment)
(A). Now create a storedprocedure to insert data to the table. Name of the storedprocedure is sp_insert[last4digitsofyourstudentid](e.g.,sp_insert7697)
(i) Now insert the following data to the table using the storedprocedure you created
id
(Last 2 digits of your student number)
name
(Your Name)
age
any
Address
(your city)
salary
any
Show all relevant Screens withsource code in Word format.
Explain the code block
PL/ SQL – Stored Procedures
Create a PL/SQL Stored Procedures to dothe following tasks
(Script is provided with thisassignment)
1. Create a table named customers_697and populate the table with data (use the script provided withthis assignment)
(A). Now create a storedprocedure to insert data to the table. Name of the storedprocedure is sp_insert[last4digitsofyourstudentid](e.g.,sp_insert7697)
(i) Now insert the following data to the table using the storedprocedure you created
id
(Last 2 digits of your student number)
name
(Your Name)
age
any
Address
(your city)
salary
any
Show all relevant Screens withsource code in Word format.
Explain the code block