Question: A very important feature provided by D B is the system catalog. In this question we will use a view from system catalog called user

A very important feature provided by DB is the system catalog. In this question we will use a view from system catalog called user_constraints which describes the constraints defined on tables in the current user's schema. You may use 'desc user_constraints' to see the columns defined in this view.
You need to define a user-defined record type called Constr, which has three columns:Write an anonymous PL/SQL block, define a cursor for retrieving the info from the view of user_constraints for the table EMP. In the executable section, your program will run a loop to fetch the values returned by the cursor, into a record variable just defined. Then print out the contents of this record.
The lines below are for your reference,Description of constraint type LETTER:P - Primary key.U - Unique key.R - Referential integrity.C - Check constraint on a table.
 A very important feature provided by DB is the system catalog.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!