Re: How to get current login value???

From: <syakobson_at_my-dejanews.com>
Date: Sat, 25 Jul 1998 14:30:11 GMT
Message-ID: <6pcq5k$83j$1@nnrp1.dejanews.com>

All you need to do is:

SELECT USER FROM dual;

Solomon Yakobson.

In article <35b99b1e.72243580_at_news.uniserve.com>, guang_at_uniserve.com (Y. Yu) wrote:
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jul 25 1998 - 09:30:11 CDT