RE: Re: Export just certain rows?

Well since we're being silly :)

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)

From: [email protected] [mailto:[email protected]] On Behalf Of Phyllis Helton
Sent: Thursday, January 26, 2012 6:41 AM
To: '[email protected]'
Subject: RE: [toad] Re: Export just certain rows?


I wanna play too!

Or where rownum between 1 and 50 . . .

Once you are in the export dialog, Dan, you can change your query by going to the dataset tab and entering your new criteria there.   That would be the only way to limit the data once you are in that dialog.

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Wim de Lange
Sent: Thursday, January 26, 2012 1:49 AM
To: [email protected]<mailto:[email protected]>
Subject: Re: [toad] Re: Export just certain rows?



where rownum <= 50 is another...... (sorry, could not resist)
Groetjes,
   Wim


2012/1/25 Matt Wilkins <[email protected]<mailto:[email protected]>>

where rownum < 51 is one way...

From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Dan Breid
Sent: Wednesday, January 25, 2012 5:16 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] Re: Export just certain rows?



Message from: DBreid


Wow, maybe I should've taken the 12 seconds to look for that checkbox [Image removed by sender.]


Now, is there a way to stop the query results at say, 50 rows (basically a way to check to see if your results are going to be along the lines of what you expect)?

Thanks for the help!

_______________________________________

Historical Messages


Author: Dan Breid
Date: Wed Jan 25 14:15:31 PST 2012
Wow, maybe I should've taken the 12 seconds to look for that checkbox [Image removed by sender.]


Now, is there a way to stop the query results at say, 50 rows (basically a way to check to see if your results are going to be along the lines of what you expect)?

Thanks for the help!
__

Author: Richard Squires
Date: Tue Jan 24 14:44:19 PST 2012
1.  Highlight the rows you want (Right click -> Row Select might help)
2.  Right click -> Export Dataset
3.  Choose how you want them exported (Excel, Inserts, etc)
4.  Tick the Export Selected Rows Only checkbox
5.  Click OK

__

Author: Dan Breid
Date: Tue Jan 24 14:10:09 PST 2012

In TOAD 10.6, I'm looking for an option that allows me to only export certain rows (i.e. the first 50) from the Data Grid.  Lil' help?

Thanks!

__
_______________________________________