Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started