| Variables [message #371448] |
Fri, 20 October 2000 12:08  |
Luis Gabriel
Messages: 11
Registered: October 2000
|
Junior Member |
|
|
Hi,
How can I assign a value of a command from operating system to a variable of oracle. I try to do this but doesn't work's:
declare usuario=!who -u|grep user1|awk '{print $1}'.
The command line return's me: user1.
How assign this value to usuario???
Could somebody help me please.
Tanks..
|
|
|
|
| Re: Variables [message #371449 is a reply to message #371448] |
Fri, 20 October 2000 12:17  |
Marcus Fernando
Messages: 34
Registered: September 2000
|
Member |
|
|
|
If you whant to know who is the user from a session, why don't you use the v$session view ? There is the information about the osuser, machine, program, etc ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
