RE: 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 | The World Depends on Sensors and Controls

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Norman Dunbar
Sent: Thursday, January 26, 2012 10:10 AM
To: [email protected]
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







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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/