Re: Default column value as Username

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 22 Nov 2002 06:48:08 +1100
Message-ID: <vDaD9.81325$g9.229164@newsfeeds.bigpond.com>

You can't. You'll have to have a before insert trigger on the table which grabs the username and inserts it into the field.

Regards
HJR "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 Thu Nov 21 2002 - 13:48:08 CST