Database Administration (MOSC)

MOSC Banner

How To Assign Particular NLS_CALENDAR To Particular User

edited Jan 28, 2010 8:48PM in Database Administration (MOSC) 5 commentsAnswered
** Basic Information  :

-  I use Data Base 10g .

 - We have One Data Base is Called (orcl) and We have Two Oracle User are Called (ghan) and (jed) .

- In The Oracle User (ghan) and (jed)  The Default Value For NLS_CALENDAR parameter for  nls_session_parameters  is Gregorian  .

SQL> select * from nls_session_parameters;

      PARAMETER                       VALUE

---------------------------      -------------------------------

NLS_LANGUAGE                   AMERICAN

NLS_CALENDAR                   GREGORIAN

----------------------------------------------------------------------------------------------------------------------------  

** The Problems Definition  :

How To Assing Two Difference NLS_CALEND To Tow Users In Same D.B

That mean I want to assign  NLS_CALENDAR = 'ARABIC HIJRAH' To (ghan) User

And NLS_CALENDAR = Gregorian To (jed) User

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center