Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How Many Anonymous Blocks Can Be Defined
How Many Anonymous Blocks Can Be Defined? - Oracle DBA FAQ - Introduction to PL/SQL
✍: 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.
2007-04-25, 4721👍, 0💬
Popular Posts:
How Do I Run JUnit Tests from Command Window? To run JUnit tests from a command window, you need to ...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...
How To Create an Add-to-Bloglines Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...
How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions To...
How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...