Page 1 of 1

Write PL/SQL programs for the following requirements :  Select any 1 course (any courses of your choice) from Term 3 of

Posted: Mon Jun 06, 2022 1:59 pm
by answerhappygod
Write PL/SQL programs for the following requirements :
 Select any 1 course (any courses of your choice) from Term 3
of your program(CSAM )
 Write PL/SQL script to create a table structure to enter the
details of a course It is you to decide which all columns should be
included in the script. Copy the script in a .sql file and also
paste the code in MSWord file. This will be the script 1 file for
Exercise 2.
 Create the 2nd script file to write PL/SQL code to input the
field values in variable for a row and insert the data into
previously created table. Copy the script in a .sql file and also
paste the code in MSWord file. This will be the script 2 file for
Exercise 2.
 Create the 3 rd script file to write PL/SQL code to read
record from the table and display them. Copy the script in a .sql
file and also paste the code in MSWord file. This will be the
script 3 file for Exercise 2.