Posted By: Felix Export - order by - 01/29/03 07:52 PM
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.
Posted By: Marco Kalter Re: Export - order by - 01/29/03 09:37 PM
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
© Allround Automations forums