Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

You can also choose to apply a constraint to new data only by specifying ENABLE NOVALIDATE

The default is ENABLE VALIDATE. SQL> SQL> -- create demo table SQL> create table myTable(   2    id           NUMBER(2),   3    value        NUMBER(6,2)   4  )   5  / Table created. SQL> SQL> ALTER TABLE myTable   2  ADD CONSTRAINT uq UNIQUE (id) DISABLE; Table altered. SQL> SQL> ALTER TABLE myTable   2  DISABLE CONSTRAINT uq; Table altered. SQL> SQL>                                                                                                                                                                   Null?    Type SQL> ALTER TABLE myTable   2  ENABLE NOVALIDATE CONSTRAINT uq; Table altered. SQL> SQL> drop table myTable   2  / Table dropped. SQL>