18 April 2008

How to For...Loop in SQL statement for Oracle?

-- Assign the data in Table_Name to objX in For...Loop method.
For objX In (Select Field_Name From Table_Name) Loop

-- You can use the Field_Name in Table_Name with objX object now.
If objX.Field_Name = 'OK' Then
-- Some process that you want to do.
End If;

End Loop;

No comments: