Home » SQL & PL/SQL » SQL & PL/SQL » FOR???
FOR??? [message #86] Fri, 11 January 2002 10:22 Go to next message
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.-
Re: FOR??? [message #89 is a reply to message #86] Fri, 11 January 2002 10:33 Go to previous message
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: Thu Mar 28 16:53:48 CDT 2024