CODEWITHSUNDEEP
oracle-databaseplsqltoad
Raj More
Raj More

Reputation: 48014

toad splits my output

When I run a query in Toad, sometimes it splits the output into blocks. How do I get the whole dataset as a single set?

alt text

Upvotes: 2

Views: 753

Answers (3)

Mike Meyers
Mike Meyers

Reputation: 2895

This is the SQL*Plus pagesize option which default to 24. it can be modified with the command set pagesize 0 to get rid of it completely.

In SQL*Plus, there is also an option to set this automatically using a login.sql or glogin.sql script. This functionality also appears to be available in Toad (although I don't have Toad here to test it out on). Further details are here on this ToadWorld blog post.

Upvotes: 2

Craig
Craig

Reputation: 5820

That looks like the pagesize parameter. The only problem is that I only know how to turn them all off:

set pagesize 0

or put them up to every 50000 lines:

set pagesize 50000

I don't believe Oracle lets you go higher than that. So I don't know how to get it to print just the first header and nothing else.

Upvotes: 3

heximal
heximal

Reputation: 10517

it's not exactly toad, it's standard behavior or oracle db. you need to order by some field e.g. to get whole dataset

Upvotes: 0

Related Questions