OracleVillage

How To Use an 'Order By' in Discoverer
If you enter a SQL statement with an 'order by' in a Custom Folder in the Administration Edition of Discoverer 3.1, you will get following message: "THE CUSTOM SQL ENTERED CONTAINS AN ORDER BY CLAUSE AND IS THEREFORE INVALID"
Use the following to avoid the error message:
a) Use the select without 'order by' and save the custom folder in the business area
b1) Start the Discoverer User Edition 3.1 - login under the same schema as in the Administration Edition (i.e, the eulowner this would preclude applications mode eul's- create a new Workbook - choose table (as the sort works only for tables)- choose the custom folder from the business area - place it under selected and finish it. Yyou have now two possibilities:c1)- select the column in the table (B) - press the right mouse button - choose the sort option you want to have, here: 'sort low to high'or:c2)- from menu choose Tools -> Sort.. -> Add button - choose item B- press Finish and save the Workbook
b2) start the Discoverer Administration Edition 3.1 - go to the Item Classes tab.- use the Item Class Wizard to create a new item class.- select the Alternative Sort option in the first Item Class Wizard- select the item you want to use for the list of values. the alternative sort item must be in the same folder as the list of values to be sorted,- select the item that contains the alternative sort values- select the items that will use the alternative sort- finish it
Short example to use:select '66' A, '1' B from dual UNION select '33' A, '2' B from dual (order by B) this works only in sqlplus.