Re: Grab current user name

Well, still sounds pretty new to me... ;-)

declare
  l_username varchar2(60);
begin
  select user
  into l_username
  from dual;
end;

will this work for you?

Reinier.

Rob <rrosenheim_at_my-deja.com> wrote in message news:8qr0r7$d3n$1_at_nnrp1.deja.com...
> OK, I'm not that new at this. I know about retrieving the username
> from SQL*Plus. I need to know how to do it from a form using PL/SQL.
>
> rob
>
> In article <39ccd5ef.13947154_at_news.netvigator.com>,
> shanx_at_removethis_shanx.com (Shashank Tripathi) wrote:
> > Just type USER at the SQL*Plus prompt.
> >
> > sql> user
> >
> > Shanx.
> >
> > On Thu, 21 Sep 2000 19:29:55 GMT, Rob <rrosenheim_at_my-deja.com> wrote:
> >
> > | Good day all...
> > |
> > | I'm kind of new at this, so please bear with me. I'm developing
 a data
> > | entry form with Form Builder and need to capture the currently
 logged
> > | on user's username and insert it into a field in each record that
 is
> > | added by said user. Any help would be greatly appreciated, and
 please
> > | don't hesitate to be extremely explicit with your instructions.
> > | Thanks...
> > |
> > |
> > | Sent via Deja.com http://www.deja.com/
> > | Before you buy.
> >
> > --
> > It usually takes a long time to find a shorter way.
> >
> > Shashank Tripathi
> > http://shanx.com
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 27 2000 - 01:16:19 CDT