Re: default value for date field
u mean to set default value for date field i have to write triggers.
i will explain my problem clearly.
i have a table t.
create table t
(
valid_upto date default current_date,
created_on timestamp default current_timestamp
)
but first column shows errors and second works.
can i set the default value for date field like that? if not how to?
Subject
Views
Written By
Posted
81479
February 05, 2007 04:41AM
40210
February 05, 2007 09:44AM
Re: default value for date field
40981
February 06, 2007 01:16AM
42899
February 06, 2007 09:39AM
29413
February 07, 2007 05:22AM
16150
January 16, 2009 06:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.