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:
What Are the Execution Control Statements
What Are the Execution Control Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics
✍: FYIcenter.com
PL/SQL supports three groups of execution control statements:
The script below shows some execution control statements:
DECLARE total NUMBER; BEGIN total := 0; LOOP total := total+1; IF total >= 10 THEN GOTO print; END IF; END LOOP; <> DBMS_OUTPUT.PUT_LINE('Total counts: ' || TO_CHAR(total)); END;
This script should print this:
Total counts: 10`
2007-04-30, 4906👍, 0💬
Popular Posts:
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...
How can I use tables to structure forms Small forms are sometimes placed within a TD element within ...
What is the difference between Session State and ViewState? ViewState is specific to a page in a ses...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statement...