Home » SQL & PL/SQL » SQL & PL/SQL » Environment variables
Environment variables [message #230713] Thu, 12 April 2007 11:19 Go to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
Hi,

Need to know how we can see all the environment variables in windows for oracle e.g oracle_path, nls_lang.How can we change the values? when i go to My computer-properties-Advanced-Environment variables, It does not show oracle_path/nls-lang/tns_admin etc.Am i looking at the correct location? Moreover, can the variables be viewed by using sql query?Please help.

Khushi
Re: Environment variables [message #230741 is a reply to message #230713] Thu, 12 April 2007 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Regedit: HKLM\Software\Oracle.

Regards
Michel
Re: Environment variables [message #230746 is a reply to message #230713] Thu, 12 April 2007 12:45 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
From a command window (RUN CMD) issue:
$ SET
Re: Environment variables [message #230748 is a reply to message #230746] Thu, 12 April 2007 12:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ana, unfortunatly, no.
The values of ORACLE_HOME, NLS_LANG, TNS_ADMIN and so on are only stored in registry (by default, you can also add it in your environment, but Oracle installation does not do it).

Regards
Michel
Re: Environment variables [message #230818 is a reply to message #230713] Fri, 13 April 2007 00:28 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
Hi,

I am a bit confused about environment variables. Aren't oracle_path, NLS_lang env. variables? If so, shouldn't it be shown under Properties-advanced-Environment varaibles? If not what is the difference? Can the variables be fetched from sql query?

khushi
Re: Environment variables [message #230824 is a reply to message #230818] Fri, 13 April 2007 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Aren't oracle_path, NLS_lang env. variables?
Not on Windows (in the genuine sense), they are registry parameters and so can be seen as environement variables.

shouldn't it be shown under Properties-advanced-Environment varaibles?
No, see above.

If not what is the difference?
See above.

Can the variables be fetched from sql query?
Not really, a SQL query is executed on server. The environment variables are from client.

Regards
Michel

Re: Environment variables [message #230830 is a reply to message #230713] Fri, 13 April 2007 01:01 Go to previous message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
Thanks for clearing my doubts.Khushi
Previous Topic: creating auto generation column
Next Topic: how to print xmlgen result
Goto Forum:
  


Current Time: Mon Dec 05 13:18:34 CST 2016

Total time taken to generate the page: 0.11184 seconds