Home » RDBMS Server » Server Administration » environment variables (db 10gr2 ,windows xp)
environment variables [message #483477] Mon, 22 November 2010 06:51 Go to next message
kamransagri
Messages: 13
Registered: May 2006
Location: india
Junior Member
hi,

how can we see/set the environment variables through enterprise manager or through command prompt.

e.g (setting external procedure calls DDLs)etc.

Re: environment variables [message #483480 is a reply to message #483477] Mon, 22 November 2010 07:26 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Command prompt:

How to set it?
M:\>set my_variable=xzy

How to check its value?
M:\>set my_variable
my_variable=xzy

How to undefine it?
M:\>set my_variable=

How to check its value #2?
M:\>set my_variable
Environment variable my_variable not defined
Re: environment variables [message #483490 is a reply to message #483477] Mon, 22 November 2010 07:47 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You cannot see client environment variables.
You can see server one using on of the Java class or using dbms_system.get_env (if your DBA allow you to use it).

Regards
Michel
Previous Topic: How to get hardware information from database level
Next Topic: Sniped process
Goto Forum:
  


Current Time: Fri Nov 29 08:40:55 CST 2024