RosettaCodeData/Task/Loops-While/SQL-PL/loops-while.sql

13 lines
181 B
SQL

--#SET TERMINATOR @
SET SERVEROUTPUT ON @
BEGIN
DECLARE I SMALLINT DEFAULT 1024;
Loop: WHILE (I > 0) DO
CALL DBMS_OUTPUT.PUT_LINE(I);
SET I = I / 2;
END WHILE Loop;
END @