RE: Re: Export just certain rows?

That won't limit the number of rows returned, it will just decrease the number of rows returned per fetch.

From: [email protected] [mailto:[email protected]] On Behalf Of Matt Wilkins
Sent: Thursday, January 26, 2012 9:59 AM
To: [email protected]
Subject: RE: [toad] Re: Export just certain rows?


But you can limit the number of returned rows by setting the OCI buffer array size as well...as long as you're using F9 (run as statement).

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Zarzycki, Michael
Sent: Thursday, January 26, 2012 10:25 AM
To: [email protected]<mailto:[email protected]>
Subject: RE: [toad] Re: Export just certain rows?



Yes, the silliness is rampant. Can I assume the answer to the OP's original question is that TOAD has no utility for extracting a portion of a result set after the query has been run? You can only control that by limiting the return in your SQL.

The only kluge I can come up with is you let the query spool its initial 500 rows, start the extract, then cancel it. You will get more than 50 rows, but much fewer than the total result.

Best regards,
Mike
Michael S. Zarzycki, MTS | IT Engineering, Integrations, and Programming Manager | Sensata Technologies, Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com<http://www.sensata.com> | The World Depends on Sensors and Controls

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of Norman Dunbar
Sent: Thursday, January 26, 2012 10:10 AM
To: [email protected]<mailto:toad%40yahoogroups.com>
Subject: Re: [toad] Re: Export just certain rows?

On 26/01/12 14:58, Bert Scalzo wrote:
> Well since we're being silly J
>
> Where rownum in
> (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50)

In which case, I can go even sillier and lees effient as well:

where mod(rownum) in (1,2, ..... 51)

Might as well read the whole table eh? ;-)

--
Cheers,
Norm. [TeamT]

------------------------------------

Yahoo! Groups Links