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.
2018-10-30, 964👍, 0💬
Popular Posts:
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...