Re: Default column value as Username

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 23 Nov 2002 07:02:44 +0100
Message-ID: <8f6utu8fnvhgqm1q42oqho4qsjqfu73im0@4ax.com>

On 22 Nov 2002 17:00:43 -0800, rx20010101_at_yahoo.com (Rx) wrote:

>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

You've obviously never tried this. I did. It doesn't work.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Nov 23 2002 - 00:02:44 CST