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
81669
February 05, 2007 04:41AM
40310
February 05, 2007 09:44AM
Re: default value for date field
41075
February 06, 2007 01:16AM
42986
February 06, 2007 09:39AM
29514
February 07, 2007 05:22AM
16238
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.