Write a complete PL/SQL program that enables a user to interact with a database of your choice (for example you may choose employee database, or student, or a library database, … etc). The database should contain one table, and the program should enable the user to:

Insert a record into the table

Find a record in the table

Update a record in the table

delete a record from the table.

Display all the records in the table.

Make use of substitution variables to get input from the user.

To ease the coding and distribution of jobs among members, code every job in the list above in a separate procedure.

Answer rating: 100% (QA)

The full form of PLSQL is called Procedural Language for SQL The PLSQL is defined as the Oracle Database and it stores all the procedures functions packages and triggers Now let see how to Insert a re... View the full answer