PL SQL -Nested Blocks and Procedures

Learn how to nest one PL/SQL block inside another and also how to name PL/SQL blocks.

Review Questions:
1. How can you declare a variable in PL/SQL?
2. Can you add a begin statement after writing one begin statement?
3. What is the use of || in PL/SQL?
4. What is a procedcure?
5. What are the advantages of creating a procedure in PL/SQL?
6. How can you call a procedure?
7. What error does Oracle SQL plus give if the procedure has mistakes?