oracle default value for a column

Question

You know how we could use:

dateStamp DATE DEFAULT sysdate

to assign a default value to a column in table_x. What if I want to assign a default function? Can I do that?

The function will have some values from "table_params" to run some formula including a column named : "base" in table_x.

I could possibly write a cursor to loop through and run an update statement, but I was just curious if this is possible. thanks in advance.

phil · Accepted Answer · 2011-08-25 20:57:25Z

3

From Oracle documentation:

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.

Either use a trigger (as was already mentioned) or run an UPDATE statement after your INSERT statement(s) (shouldn't be a problem if you keep your DML in PL/SQL).

answered Aug 25, 2011 at 20:57

phil

7075 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lost in Alabama · Accepted Answer · 2011-08-25 20:33:56Z

2

You can write an INSERT trigger for the table that calls the function you want.

answered Aug 25, 2011 at 20:33

Lost in Alabama

1,65310 silver badges16 bronze badges

Collectives™ on Stack Overflow

oracle default value for a column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related