Re: Oracle Portal - identifying who has signed on

[Quoted] On Mon, 12 Feb 2001 13:48:45 -0000, "SDG" <simong_at_explor.co.uk> wrote:

>I am wanting to write a sql statement for a portal report that only returns
>rows for the user who has logged on.
>Is there a procedure or api to do this.
>
>Basically I am wanting to do what SYS_CONTEXT ('userenv','session_user')
>does in sqlplus for the database user.
>
>
>eg.
>
>select *
>from my_table
>where user_name = (portal sign on name)
>
>
>Thanks in anticipation.
>
>

Not sure about Portal (WebDB 3.0.6), but in WebDB 2.2 we use select UPPER(USER) into user_id from DUAL. Received on Mon Feb 12 2001 - 16:50:55 CET