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 - Introduction to PL/SQL
✍: FYIcenter.com
PL/SQL supports three groups of execution control statements:
The script below shows execution control statements:
SQL> set serveroutput on; SQL> DECLARE 2 total NUMBER; 3 BEGIN 4 total := 0; 5 LOOP 6 total := total+1; 7 IF total >= 10 THEN 8 GOTO print; 9 END IF; 10 END LOOP; 11 <> 12 DBMS_OUTPUT.PUT_LINE('Total counts: ' 13 || TO_CHAR(total)); 14 END; 15 / Total counts: 10
This sample script shows you how to use LOOP, IF, and GOTO statements.
2007-04-25, 4539👍, 0💬
Popular Posts:
What is Concern in AOP? gA concern is a particular goal, concept, or area of interesth There are m...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the da...
How Do You Uninstall JUnit Uninstalling JUnit is easy. Just remember these: Delete the directory tha...
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...