Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Run the Anonymous Block Again

By: FYIcenter.com

(Continued from previous topic...)

How To Run the Anonymous Block Again?

If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script:

SQL> set serveroutput on;

SQL> begin 
  2    dbms_output.put_line('This is a PL/SQL FAQ.'); 
  3  end;
  4  /
This is a PL/SQL FAQ.

PL/SQL procedure successfully completed.

SQL> /
This is a PL/SQL FAQ.

PL/SQL procedure successfully completed.

(Continued on next topic...)

1. What Is PL/SQL?
2. What Are the Types PL/SQL Code Blocks?
3. How To Define an Anonymous Block?
4. How Many Anonymous Blocks Can Be Defined?
5. How To Run the Anonymous Block Again?
6. What Is a Stored Program Unit?
7. How To Create a Stored Program Unit?
8. How To Execute a Stored Program Unit?
9. How Many Data Types Are Supported?
10. What Are the Execution Flow Control Statements?
11. How To Use SQL Statements in PL/SQL?
12. How To Process Query Result in PL/SQL?
13. How To Create an Array in PL/SQL?
14. How To Manage Transaction Isolation Level?
15. How To Pass Parameters to Procedures?
16. How To Define a Procedure inside Another Procedure?
17. What Do You Think about PL/SQL?