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 is the system catalog. In this question we will use a view from system catalog called userconstraints which describes the constraints defined on tables in the current user's schema. You may use 'desc userconstraints' to see the columns defined in this view.
You need to define a userdefined record type called Constr, which has three columns:Write an anonymous PLSQL block, define a cursor for retrieving the info from the view of userconstraints 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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
