Search code examples
oracle-databasesessiontimestamporacle-sqldeveloperalter

Altering session permanently

Is it possible to alter the session permanently even after i close my oracle sql developer?

An example of the statement that i want to alter:

Alter Session Set Nls_Timestamp_Tz_Format='HH24:MI TZR';

The above statement only allow me to alter the current session and not making it permanently.

Thanks

Solution

  • If you just want to change the default value for SQL Developer, you can do that in the SQL Developer settings. In SQL Developer 3.1 (the same settings exist in earlier versions though the navigation may be slightly different), Tools | Preferences | Database | NLS allows you to specify a Timestamp Format and a Timestamp TZ Format. SQL Developer will then automatically issue the appropriate ALTER SESSION commands for you whenever it creates a new session.