Collections:
How Many Anonymous Blocks Can Be Defined in Oracle
How Many Anonymous Blocks Can Be Defined in Oracle?
✍: FYIcenter.com
An anonymous block is stored in the user's current session without any name. So you can only define one anonymous block at any time. If you define another anonymous block, the new block will replace the previously defined block, as shown in the following script:
SQL> set serveroutput on; SQL> begin 2 dbms_output.put_line('Hello world!'); 3 end; 4 / Hello world! PL/SQL procedure successfully completed. 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.
⇒ Run the Anonymous Block Again in Oracle
⇐ Define an Anonymous Block in Oracle
2018-10-30, 1826🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...