Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a PL/SQL code: write an anonymous block program unit that inserts a user-input value into employees table and prints a message 'record is inserted

Write a PL/SQL code:

write an anonymous block program unit that inserts a user-input value into employees table and prints a message 'record is inserted successfully' as following:

Employee_id: user-input

Last name: user-input

First_name: user-input

Department_number: user-input

Manager_id : user-input ( nullable)

The program raises an exception if "dup_val_on_index" and print the message "department number is duplicated".

Try two cases:

Input values (employee_id:110, last_name : Bandarus, first_name: Prakash, department_number : 3, Manager_id:8)

Input values (employee_id: 8, last_name : Mark, first_name: Smith, department_number : 8, Manager_id:Null)

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

More Books

Students also viewed these Databases questions