RE: Re: Export just certain rows?

where rownum < 51 is one way...

From: [email protected] [mailto:[email protected]] On Behalf Of Dan Breid
Sent: Wednesday, January 25, 2012 5:16 PM
To: [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!

__
_______________________________________