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 -> Custom functions in DDL for default column values ?

Custom functions in DDL for default column values ?

From: Curmudgeon <richard.a.elliott_at_williams.com>
Date: 28 Jan 2005 08:49:33 -0800
Message-ID: <1106930973.600058.221060@z14g2000cwz.googlegroups.com>


Is it possible to set a default for a colume to be a custom function ?

In other words instead of the function sysdate, could I write my own function and set the default to myfunction ?

I know I can do something very similar in a trigger, but it's a lot easier for me to change DDL than application trigger source code. Received on Fri Jan 28 2005 - 10:49:33 CST

Original text of this message

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