Is there in any other way to select one record at a time?

philipraju · New User Joined: 16 Apr 2006 Posts: 29

I have one file with 10000 records. Is there any other way to select one record at a time from a set of selected records (cursor is facilitating such type... but for more number records is there any other way to hold a set of records)?

ap_mainframes · Posted: Thu Jun 08, 2006 9:22 am

I am not sure what you are trying to say here.
Please explain in detail, with sample input and expected output.

Ap_mainframes

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi,
If you read the file sequentially, I think it "selects" one record at a time !

However, I am not really sure about your requirment. Can you explain it in details?

Thanks,
Parikshit

philipraju · New User Joined: 16 Apr 2006 Posts: 29

Is there any other alternative to CURSOR to handle the records

vicky10001 · Active User Joined: 13 Jul 2005 Posts: 136

u can use select * from emp fetch first 1 row only