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:

[code=oracle]

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

[/code]

[hiral amit patel]

check constraint

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:

[code=oracle]

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

Table created.

SQL>

[/code]

[hiral amit patel]

check constraint

Hi amit

I m using oracle 8i

[amitpatel66]

Please post the output of the below query:

[code=oracle]

SELECT * FROM v$version

[/code]