Skip to content

Small exercises in Oracle PL/SQL to test knowledge on SELECT INTO statement

Notifications You must be signed in to change notification settings

porpup/PL-SQL_SELECT_INTO

Repository files navigation

PL-SQL_SELECT_INTO

Question 1: (user scott)

 Create a procedure that accepts an employee number to display the name of the department where he works, his name, his annual salary (do not forget his one time commission)
Note that the salary in table employee is monthly salary.
Handle the error (use EXCEPTION)
HINT: the name of the department can be found from table dept.

Question 2: (use schemas des02, and script 7clearwater)

 Create a procedure that accepts an inv_id to display the item description, price, color, inv_qoh, and the value of that inventory.
Handle the error ( use EXCEPTION)
Hint: value is the product of price and quantity on hand.

Question 3: (use schemas des03, and script 7northwoods)

 Create a function called find_age that accepts a date and return a number.
The function will use the sysdate and the date inserted to calculate the age of the person with the birthdate inserted.
Create a procedure that accepts a student number to display his name, his birthdate, and his age using the function find_age created above. Handle the error ( use EXCEPTION)

Question 4: (use schemas des04, and script 7software)

 We need to INSERT or UPDATE data of table consultant_skill , create needed functions, procedures … that accepts consultant id, skill id, and certification status for the task. The procedure should be user friendly enough to handle all possible errors such as consultant id, skill id do not exist OR certification status is different than ‘Y’, ‘N’. Make sure to display: Consultant last, first name, skill description and the confirmation of the DML performed (hint: Do not forget to add COMMIT inside the procedure)

About

Small exercises in Oracle PL/SQL to test knowledge on SELECT INTO statement

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published