Re: Re: Export just certain rows?

Norman Dunbar <[email protected]> Thu, 26 Jan 2012 15:10:20 +0000

Newsgroups	gmane.comp.db.oracle.toad.free
Message-ID	<[email protected]>

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

<*> 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/