Re: How to get current login value???

From: Zafer Mutlu AKTAN <zafer_at_redshift.com>
Date: Sat, 25 Jul 1998 11:46:43 -0700
Message-ID: <6pd9om$ero$1@supernews.com>

I did not understand the question well enough, but this is the way I am accessing to the database id for my reports:

SELECT USER FROM DUAL;
I don't know if this help -
Regards
Zafer

Y. Yu wrote in message <35b99b1e.72243580_at_news.uniserve.com>...
>Hi there,
>
> I am trying to find out how to get current login id in order
>to run a query like this:
>
> SELECT name, login_id
> FROM table1
> WHERE login_id = "current login id"
>
>Say if i logon to Scott, I want "current login id"="scott".
>Is there any ways to do this?
>
>
>Many thanks for your help
>
>
>
>
>
>
Received on Sat Jul 25 1998 - 13:46:43 CDT