This content has been marked as final. Show 2 replies
twinklin_girl wrote:Two things you can do...
I need to develop a form which will fetch many records from the database from one table . I could used go_block('blockname') & execute_query but I want to do something that will fetch the data and place it in a non db block instead of looping through the db block . What should I use ? Cursor ?
I'd be grateful for any help please with an example of the code . Thanks.
Create a view and based on that view make your form.
Another is How to Base a block on a FROM Clause Query
Hope this helps
Mark correct/helpful to help others to get right answer(s).*
Querying all of 1M records will be very inefficient no matter what method you use. On the other hand I really do not understand why basing block on table is not an option as this is in my belief the most simple an efficient option? What did you meant by "looping through the db block"? If I understood you correctly you even don't want to display those records. If so you can use record group. But again querying 1M of records it is kind of obscure.