Home » SQL & PL/SQL » SQL & PL/SQL » i want to know how can i go through page by page in oracle
i want to know how can i go through page by page in oracle [message #1338] Mon, 22 April 2002 14:06 Go to next message
pavani
Messages: 32
Registered: April 2002
Member
hi
i wrote a programe and i got a result that is very huge.and i want to see the result page by page so how can i get through this problem.
thanks for helping
Re: i want to know how can i go through page by page in oracle [message #1341 is a reply to message #1338] Tue, 23 April 2002 02:20 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
What tool are you using?

In sqlplus you got the pause commande: SET PAUSE ON
Re: i want to know how can i go through page by page in oracle [message #1361 is a reply to message #1338] Wed, 24 April 2002 07:14 Go to previous message
motiram
Messages: 21
Registered: January 2001
Junior Member
If you are doing using java, http this is how u shud do it.

1. Fetch all keys into a array.
2. Get first n keys, fetch data and display.
3. If user says next, keep a flag where you stopped, and fetch next n keys and the data.
Let me know if you get into any problems.

Cheers
Previous Topic: urgent ...how to make this simple query run faster
Next Topic: Trigger Information
Goto Forum:
  


Current Time: Fri Mar 29 07:55:23 CDT 2024