Could I use user define function as default value of a column?

[Jack.Lee]

I wanna add a user define function as default value of a column.But
oracle raise an error.Could I do that?

Thanks a lot!
Jack.Lee

[Lothar Armbrüster]

"Jack.Lee" <gzja...@gmail.com> writes:

Oracle's documentation (for 11g) says:

Restriction on Default Column Values
A DEFAULT expression cannot contain references to PL/SQL functions or to other
columns, the pseudocolumns CURRVAL, NEXTVAL, LEVEL, PRIOR, and ROWNUM, or date
constants that are not fully specified.

Maybe you could use a before insert trigger to accomplish your needs.

Hope that helps,
Lothar

--
Lothar Armbrüster | lothar.ar...@t-online.de
Hauptstr. 26 |
65346 Eltville |

[BicycleRepairman]

Take a look at Virtual Columns in 11g. It might not be exactly what
you're looking for, but it is incredibly useful for some of the use
cases you might be thinking of.