Answered step by step
Verified Expert Solution
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
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
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