Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have to make stored procedure I am using the oracle sql developer plz answer through the oracle sql developer Write a stored procedure called

 image

I have to make stored procedure

I am using the oracle sql developer plz answer through the oracle sql developer 


Write a stored procedure called staff_add that will add a new row to the STAFF table as described below: - - - - ID - should be calculated as 10 higher than the highest ID currently in the STAFF table NAME - must be provided as input DEPT - set this automatically to 90 JOB - must be provided as input; must be either "Sales" or "Clerk" or "Mgr" -anything else should cause an error YEARS - set this automatically to 1 SALARY - must be provided as input COMM - must be provided as input WHAT TO HAND IN: A copy of your stored procedure and the output of a successful insert, and error handling

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

Business and Professional Ethics

Authors: Leonard J. Brooks, Paul Dunn

7th edition

1285182227, 978-1285182223

More Books

Students also viewed these Databases questions

Question

Draw a picture consisting parts of monocot leaf

Answered: 1 week ago