Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

More Books

Students also viewed these Databases questions

Question

4. Will technology eliminate the need for HR managers?

Answered: 1 week ago