Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Default column value as Username

Default column value as Username

From: Frank Ashley <frank.ashley_at_ntlworld.com>
Date: Thu, 21 Nov 2002 19:40:01 -0000
Message-ID: <FGaD9.2615$0p6.411412@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:40:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US