Collections:
Use "WHILE" Loop Statements in Oracle
How To Use "WHILE" Loop Statements in Oracle?
✍: FYIcenter.com
If you have a block of codes to be executed repeatedly based a condition, you can use the "WHILE ... LOOP" statement. Here is a sample script on WHILE statements:
DECLARE total NUMBER; BEGIN total := 0; WHILE total < 10 LOOP total := total+1; END LOOP; DBMS_OUTPUT.PUT_LINE('Total counts: ' || TO_CHAR(total)); END;
This script should print this:
Total counts: 10
⇒ Use "FOR" Loop Statements in Oracle
⇐ Use "IF" Statements with Multiple Conditions in Oracle
2018-07-13, 1403🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...