Module II

Creating Procedures  

• Describe the uses ofprocedures
  
• Create client-side andserver-side procedures 
  
• Create procedures withparameters 
  
• Declare subprograms 
  
• Invoke a procedure
  
• Remove a procedure 
  

Creating Functions

• Describe the uses offunctions
  
• Create client-side andserver-side functions 
  
• Invoke a function
  
• Remove a function 
  
• Differentiate between aprocedure and a function
  

Creating Packages 

·        Describe packages and list their possible components

·        Create a package to grouptogether related variables, cursors, constants      

·        Exceptions,procedures, and functions         

·        Make a package constructeither public or private

·        Invoke a package construct  More Package Concepts

·        Write packages that use theoverloading feature

·        Avoid errors with mutuallyreferential subprograms 

·        Initialize variables with aone-time-only procedure

·        Describe the purity of afunction 

·        Describe persistent states   

Oracle Supplied Packages

·        Describe the use andapplication of some OracleServer supplied packages:

·        DBMS_PIPE  DBMS_DDL,DBMS_JOB ,DBMS_OUTPUT Write dynamic SQL using DBMS_SQL    

Creating Database Triggers

·        Describe database triggersand their use 

·        Create database triggers    

·        Describe database triggerfiring rules

·        Remove database triggers

More Trigger Concepts 

·        Explain the rules governingtriggers

·        Implement triggers

Managing Subprograms and Triggers 

·        Describe system privilegerequirements

·        Describe object privilegerequirements        

·        Managing stored objectsusing the data dictionary

·        Debug subprograms

Managing Dependencies 

·        Track procedural dependencies 

·        Predict the effect of changing a database objectupon stored proceduresand functions

·        Manage procedural dependencies