PLSQL_7_3_Practice.docx - 1 www.oracle.com/academy Database...

This preview shows page 1 - 3 out of 4 pages.

The preview shows page 1 - 3 out of 4 pages.
1Database Programming with PL/SQL7-3:Trapping User-Defined ExceptionsPractice ActivitiesVocabularyIdentify the vocabulary word for each definition below:RAISE_APPLICATION_EUse this statement to raise a named exception.
Try It / Solve ItAll the questions in this exercise use a copy of the employees table. Create this copy by running thefollowing SQL statement:
1.Create a PL/SQL block that updates the salary of every employee to a new value of 10000 in achosen department. Include a user-defined exception handler that handles the condition where norows are updated and displays a custom message. Also include an exception handler that will trapany other possible error condition and display the corresponding SQLCODE and SQLERRM. Testyour code three times, using department_ids 20, 30, and 40.
2

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
JORGE OMAR JASSO LUNA
Tags
Control flow

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture