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 To Define an Anonymous Block
How To Define an Anonymous Block? - Oracle DBA FAQ - Introduction to PL/SQL
✍: 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.
2007-04-25, 5326👍, 0💬
Popular Posts:
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
How To Fade Image Edges to Background Colors? - PSP Tutorials - Fading Images to Background Colors w...
What is the quickest sorting method to use? The answer depends on what you mean by quickest. For mos...
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
How you will enable front-end validation based on the xml in validation.xml? The <html:javascr...