Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Default column value as Username
Simply put "default (user)" after the column datatype definition.
"Frank Ashley" <frank.ashley_at_ntlworld.com> wrote in message news:<FGaD9.2615$0p6.411412_at_newsfep2-win.server.ntli.net>...
> I need to put the current user name as a column default. I can get the
> username from
> SELECT USERNAME FROM V$SESSION
> but how do I put this in the default clause?
>
> Frank
Received on Fri Nov 22 2002 - 19:00:43 CST