|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Dell PowerEdge Servers
|
|
#1
August 15th, 2004, 06:09 PM
|
|||
|
|||
|
URGENT PLEASE: I want help in Order by from FRENCH title and using union statements
Dear all,
I have a union of two tables. I want to order by english and as well as french titles. Ordering english titles are fine, but the French accent "é,É" coming after the letter z, I want them comes after E,e. I am using "ORDER BY NLSSORT(aname,'NLS_SORT = French')" This works for single table order by, but for union of two table, I am getting the error, "ERROR at line 8: ORA-01785: ORDER BY item must be the number of a SELECT-list expression" This is my query: select substr(link_name_fr,1,50) as aname, link_id as ID from rp_link union select substr(event_name_fr,1,50) as aname, event_id as ID from rp_event ORDER BY NLSSORT(aname,'NLS_SORT = French') Can you tell me what was wrong and how can I fix this problem? Thanks, SM
|
|
#2
August 16th, 2004, 03:09 AM
|
|||
|
|||
|
Code:
select aname,id from ( select substr(link_name_fr,1,50) as aname, link_id as ID from rp_link union select substr(event_name_fr,1,50), event_id from rp_event) dt ORDER BY NLSSORT(aname,'NLS_SORT = French')
|
|
#3
August 16th, 2004, 03:28 AM
|
|||
|
|||
|
Quote:
ORDER BY NLSSORT(1,'NLS_SORT = French') as the error message suggests?
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > URGENT PLEASE: I want help in Order by from FRENCH title and using union statements |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
