Adding a check constraint that allows null values : Alter Constraints « Constraints « Oracle PL / SQL






Adding a check constraint that allows null values

 

SQL>
SQL>
SQL> CREATE TABLE product (
  2       product_name  VARCHAR2(25),
  3       product_price NUMBER(4,2),
  4       purchase_date DATE
  5       );

Table created.

SQL>
SQL> ALTER TABLE product ADD (
  2       CONSTRAINT reasonable_stock_date CHECK(
  3            TO_CHAR(purchase_date, 'YYYY-MM-DD') >= '2001-12-31'
  4            )
  5       );

Table altered.

SQL>
SQL> INSERT INTO product VALUES ('S', 49, '30-DEC-01');
INSERT INTO product VALUES ('S', 49, '30-DEC-01')
*
ERROR at line 1:
ORA-02290: check constraint (JAVA2S.REASONABLE_STOCK_DATE) violated


SQL>
SQL> drop table product;

Table dropped.

SQL>
SQL>

 








Related examples in the same category