Order by Clause in Oracle Enterprise stage of Parallel jobs

[jojipjohn]

Can we give Order by clause in oracle Enterprise stage of parallel jobs. If yes where are we giving this property.

[kris007]

You should select your read method as user-defined sql and then use ORDER BY statement.

[kumar_s]

You can have Order by / Having in 'Others' option in SQL builder.

[csrazdan]

As suggested above you can either use User Defined SQL query of use SQL builder for Orderby clause.

But I think you are talking about Read method as Table and you have option only for SELECT LIST and WHERE Clause.

There is a work arround, add WHERE Clause option and enter WHERE condition and after that you can write ORDER BY...... If you do not have WHERE condition for the SQL, still add WHERE Clause option and enter condition as 1=1 ORDER BY.....

Hope it helps....

[prabu]

As suggested above you can either use User Defined SQL query of use SQL builder for Orderby clause.


There is a work arround, add WHERE Clause option and enter WHERE condition and after that you can write ORDER BY...... If you do not have WHERE condition for the SQL, still add WHERE Clause option and enter condition as 1=1 ORDER BY.....

Hope it helps....

yes, that's a good trick when you have to use NULLS LAST/FIRST as well in the order by clause

[kumar_s]

SQL Builder has option called "Sort Order" selecting the corresponding column with sort method (Asc or Dsc) will give the required output, which doesn't require 'Where' clause.