Creating Stored Procedures and Functions Differentiate between anonymous blocks and subprograms Create a simple procedure and invoke it from an anonymous block Create a simple function ID: 509187
Download Presentation The PPT/PDF document "Creating Stored Procedures and Functions" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Creating Stored Procedures and FunctionsSlide2
Creating Stored Procedures and Functions
• Differentiate between anonymous blocks and subprograms
• Create a simple procedure and invoke it from an anonymous block
• Create a simple function
• Create a simple function that accepts a parameter
• Differentiate between procedures and functionsSlide3Slide4Slide5Slide6Slide7Slide8
The source of the procedure is stored in the
user_source
table. You can check the source for the procedure by issuing the following command:
SELECT * FROM
user_source
WHERE name='ADD_DEPT';
Slide9Slide10Slide11Slide12Slide13Slide14Slide15Slide16