check constraint

[todashah]

how can i put check constraint for date while creating a table.
I want to pass a constant as a date and do not want to pass as a database variable.

[amitpatel66]

Try this:

 
create table t12(dat date, CONSTRAINT my_cons CHECK (dat BETWEEN '01-JAN-2009' AND '31-JAN-2009'))
 
 

[hiral amit patel]

i have tried that one but not able to create such table.
the following error is being generated


create table t12(dat date,constraint my_cons check(dat between '01-jan-2009' and '31-jan-2009'))
*
ERROR at line 1:
ORA-02436: date or system variable wrongly specified in CHECK constraint

[amitpatel66]

Which database version you are using?

[amitpatel66]

I am able to create the table using same code as shown:

 
SQL> create table t12(dat date,constraint my_cons check(dat between '01-jan-2009' and '31-jan-2009')
)
  2  /
 
Table created.
 
SQL> 
 
 

[hiral amit patel]

Hi amit

I m using oracle 8i

[amitpatel66]

Please post the output of the below query:

 
SELECT * FROM v$version