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:

Expand|Select|Wrap|Line Numbers

  
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:

Expand|Select|Wrap|Line Numbers

  
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:

Expand|Select|Wrap|Line Numbers

SELECT * FROM v$version

check constraint

re: check constraint

re: check constraint

re: check constraint

re: check constraint

re: check constraint

re: check constraint

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about