Fetching Multiple rows using select statement

jasveer singh · New User Joined: 06 Mar 2006 Posts: 16

Hi ,

Can you please help me in this . I want to use a select statement to find out all the rows that satisfy a particular condition but more than one row may qualify to be fecthed . How should i proceed with the coding ?

Do i need to define a cursor or something else . Actually i am not sure how does cursor works

Regards,
jasveer Singh ,
+91-9847746542

rajandhla · Posted: Tue Feb 20, 2007 12:30 pm

you should define the cursor.........

declare the cursor..

open the cursor..
fetch the row in to host variables and to the process/logic u wish
untill all rows exhausted (100)
close the cursor..

for more info look in to the manuals.....

regards,
jr