Print Thread
Export - order by
#10162 01/29/03 07:52 PM
Joined: Apr 2001
Posts: 86
Tampa, FL, USA
F
Felix Offline OP
Member
OP Offline
Member
F
Joined: Apr 2001
Posts: 86
Tampa, FL, USA
When using PL-SQL Developer to export using sql-inserts can I add an order by clause using the where field?

Would be nice if there is a order by field.


Fair Bits...
Felix A. Hernandez
Re: Export - order by
#10163 01/29/03 09:37 PM
Joined: Aug 1999
Posts: 22,177
Member
Offline
Member
Joined: Aug 1999
Posts: 22,177
It would indeed be useful to have an order by field. I have added this to the enhancement requests.

Right now you can "use" the where clause field though, but you must include a (dummy) where clause condition. If you want to export all emp records, order by ename, you can use the following where clause:

where 1=1 order by ename

If you are already using a where clause you can simple append the order by clause of course.

------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 14 (0.007s) Memory: 2.4946 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 16:00:11 UTC
Valid HTML 5 and Valid CSS