Learn how to pass parameters to procedures.
To learn how to create procedures, watch the following video:
https://youtu.be/h5riKZOkSDU
Review Questions:
1. How can you pass parameters to procedures?
2. What does the / do in Oracle SQL plus?
3. What is the use of set serveroutput on?
4. Can you call a procedure from within a procedure?
5. Create a procedure to print Good Morning message.
6. Modify the previous procedure to print Good Morning along with the name of the person passed as a parameter.
7. Create a procedure to generate a multiplication table upto 10 of a number passed as a parameter.
Download
0 formats
No download links available.
PL SQL -Passing parameters to procedures | NatokHD