PLSQL_8_1_Practice.docx.docx - www.oracle.com/academy...

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

The preview shows page 1 - 3 out of 5 pages.
Database Programming with PL/SQL8-1:Creating ProceduresPracticeActivitiesVocabularyIdentify the vocabulary word for each definition below:SubprogramsNamed PL/SQL blocks that are compiled and stored in thedatabase.Is or AsIndicates the DECLARE section of a subprogram.
Try It / Solve It1. What is the difference between the following two pieces of code?
2Code A is an anonymous block which is an unnamed block of code.Is not stored in the databaseComplied each time it is usedCannot return valuesCannot take parameteresCODE SAMPLE BCREATE PROCEDURE pay_raise(p_empid employees employee_id%TYPE,p_percent_increaseNUMBER)ISBEGINUPDATE employeesSET salary = (salary * p_percent_increase) + salaryWHERE employee_id = p_empid;END pay_raise;

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 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
JORGE OMAR JASSO LUNA
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture