Re: Grab current user name

And of course:

declare
  l username varchar2(30);
begin
  l username := USER;
end;

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-09-27, 8:16:19, schreef "Reinier" <Reinier Dickhout_at_hetnet.nl> o ver
het thema 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> wro
 te:
> > >
> > > | Good day all...
> > > |
> > > | I'm kind of new at this, so please bear with me. I'm developi
 ng
 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 t
 hat
 is
> > > | added by said user. Any help would be greatly appreciated, an
 d
 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 Thu Sep 28 2000 - 00:24:21 CDT