Hello All:

I have one requirement to handle the deployments with different language settings. and the data to be sorted in the oder of the specified language.

Let me explain in detail.

Our Product will be deployed at one place with a said language settings say German. And the GUI will be supporting the data to be inserted or fetched in the German language.

My questions are:

Option 1:

1. Create a DB with locale language settings (german)
(NLS_LANGUAGE=GERMAN,
NLS_SORT=GERMAN,
NLS_TERRITORY=GERMANY)
This is set in INIT.ora
2. The select statements wil have simple order by columns.

Option 2:

1. Create a DB with locale language settings (german)
(NLS_LANGUAGE=GERMAN )
This is set in INIT.ora
2. The select statements wil have ORDER BY NLSSORT(COLUMN_NAME, 'NLS_SORT=GERMAN')

of the two options which one will be best. I see no change in Explain plan. I am bit confused in the implementation.


Thank you all in advance