Feature Request: Order By in Export Tables - SQL Inserts

[karthik]

Hi,

We have been doing a lot of export of data from the tables as SQL Inserts. The Where clause in the tab is very helpful. But we are kind of handicapped when it comes to take out the data in a sorted order. We have to use less productive methods.

It will be of immense help, if you provide the order by clause in the Export Tables - SQL Inserts tab.

 

[Marco Kalter]

This is already possible by using the where clause . In the where clause field, enter something like:

1 = 1 order by empno

Using this trick the where clause will be "where 1 = 1", and the results will be ordered by empno.