Collections:
Define an Anonymous Block in Oracle
How To Define an Anonymous Block in Oracle?
✍: FYIcenter.com
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;
SQL> begin
2 dbms_output.put_line('Hello world!');
3 end;
4 /
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.
⇒ How Many Anonymous Blocks Can Be Defined in Oracle
⇐ Types of PL/SQL Code Blocks in Oracle
2018-10-30, 3346🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How to convert a JSON (JavaScript Object Notation) quoted string into a regular character string usi...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...