Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Define an Anonymous Block
(Continued from previous topic...)
How To Define an Anonymous Block?
An anonymous block must have an execution part, which is a group of other
PL/SQL statements enclosed in the BEGIN ... END statement. Here is a script
on how to define a simple anonymous block with SQL*Plus:
SQL> set serveroutput on;
2 dbms_output.put_line('Hello world!');
PL/SQL procedure successfully completed.
"set serveroutput on;" allows dbms_output.put_line() to work.
"/" runs the anonymous block, which print the "Hello world!" message.
(Continued on next topic...)
- What Is PL/SQL?
- What Are the Types PL/SQL Code Blocks?
- How To Define an Anonymous Block?
- How Many Anonymous Blocks Can Be Defined?
- How To Run the Anonymous Block Again?
- What Is a Stored Program Unit?
- How To Create a Stored Program Unit?
- How To Execute a Stored Program Unit?
- How Many Data Types Are Supported?
- What Are the Execution Flow Control Statements?
- How To Use SQL Statements in PL/SQL?
- How To Process Query Result in PL/SQL?
- How To Create an Array in PL/SQL?
- How To Manage Transaction Isolation Level?
- How To Pass Parameters to Procedures?
- How To Define a Procedure inside Another Procedure?
- What Do You Think about PL/SQL?