OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » FOR???

Fri, 11 January 2002 10:22

Fred
Messages: 34
Registered: August 1999

Member

Hey!
Is there a FOR sentece in Oracle? I�d like to use a FOR instead of a WHILE.
How�s the syntax for it?
Thx,
F.-

Fri, 11 January 2002 10:33

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

declare
x number;
begin

for i in 1..10 loop
-- you dont need to declare 'i', oracle implicitly declares for you.
x:=x+i;
end loop;
end;

Previous Topic:	function-based index disabled
Next Topic:	Functions and Views

Goto Forum:

]

Current Time: Tue May 13 13:47:47 CDT 2025