Hi,
Thank you, it's exactly what I was searching for.
a+, =)
-=Clement=-
Configuration :
Toad For Oracle v9.0.1.8
Windows XP SP3 Pro
Firefox v3.0
Intel(R) Core(TM) 2 CPU T5500 @1,66GHz
3,00 GB RAM
--- In
toad@..., Jeff Smith <jeff.smith@...> wrote:
>
> Just run your select statement in the Editor with F5, you'll get all
your results and you won' t have to muck with the OCI settings for
normal queries.
>
> From:
toad@... [mailto:
toad@...] On Behalf
Of Simoneau, Roger
> Sent: Tuesday, July 15, 2008 1:12 PM
> To:
toad@...
> Subject: RE: [toad] How to fetch all rows instead of 500 rows with
Toad For Oracle ?
>
> Before I give the solution, an adage: Careful what you wish for, you
just might get it!
>
> In 9.6.1.1:
>
> View -> Options -> Schema Browser -> Data and Grids -> Limit Grid Fetch
>
> Select the option and change the number 1 to as high as you'd like.
Keep an eye on the "fetches (nnn records)". In 9.6.1.1 it's a
multiple of 500 so if you put in 100000000 (100 million), you'll
actually have a negative value.
>
> The reason for the adage: If you accidentally code something that
does a cartesian join against a rather large table you may find Toad
consume all your memory and appear to "freeze". Toad isn't actually
"freezing" when you click on the scroll bar.... it's just responding
to your request to get everything from the database based on your
query. It can take a while if you're request is for a rather large
dataset.
>
> Roger S.
>
> -----Original Message-----
> From:
toad@... [mailto:
toad@...]On Behalf Of
clementratel
> Sent: Tuesday, July 15, 2008 9:36 AM
> To:
toad@...
> Subject: [toad] How to fetch all rows instead of 500 rows with Toad
For Oracle ?
>
> Hi,
>
> When I run a query, it fetches 500 rows.
> If I want to fetch more rows I click on the scroll bar.
> I don't like it as with big results it freezes Toad.
>
> How to fetch all rows instead of 500 rows with Toad For Oracle ?
>
> a+, =)
> -=Clement=-
>
> Configuration :
> Toad For Oracle v9.0.1.8
> Windows XP Pro SP3
>
> PLEASE NOTE:
>
> This communication, including any attached documentation,
>
> is intended only for the person or entity to which it is addressed,
>
> and may contain confidential, personal and/or privileged information.
>
> Any unauthorized disclosure, copying, or taking action on the contents
>
> is strictly prohibited. If you have received this message in error,
>
> please contact us immediately so we may correct our records.
>
> Please then delete or destroy the original transmission and any
subsequent reply.
>
> Thank you.
>
