RE: Re: Export just certain rows?

Yes - your solution is essentially DE Morgan's theorem applied to the BETWEEN example code's actual underlying logic (i.e. rownum >= 1 and rownum <= 50) :)

And who said all those logic and implied math classes would not be useful in real life :)

From: [email protected] [mailto:[email protected]] On Behalf Of Simoneau, Roger
Sent: Thursday, January 26, 2012 11:01 AM
To: '[email protected]'
Subject: RE: [toad] Re: Export just certain rows?



>> where rownum < 51

>> where rownum <= 50

>> between 1 and 50

>> Where rownum in (1,2,3, ... ,48,49,50)

Don't ya just love applied logic:

Where !(rownum < 0
OR rownum > 50)

Roger S.

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.