i have a requirement to fetch the 3laks records from SQL server every day.
i written the select and update quires as
Select <filed_names> from Table_Name where flag = 0 and rownum<= 100
Update Table_Name set flag = 1 where flag = 0 and rownum<=100
is this quires correct, if yes per every 60 sec i will get 100 records and i can't fetch total records in24 hours.
can i increase the records as 300 then heap memory issue will rise.
please suggest how to fetch large data from SQL and with in min time.