Using System Variables in a SQL Query
773823May 19 2010 — edited May 19 2010Hi!
I´m new to Oracle and SQL so i don´t know very much about it.
There is miy Problem:
Is there a way to Use the System Variable %USERNAME% in an SQL Query?
I tried .... where table.shorttag = '%USERNAME%' ;
but this doesnt work.
Is Oracle able to handle Systemvariables? Or is there another way to use the current Windows User in an SQL Query.
It is very Important to use the current Windows user and not the Oracle user.
Thank you,
Mfg