Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

Create table with Unique Constraints

SQL> SQL> create table department (   2      Dept_no      NUMBER(3),   3      Dept_name    VARCHAR2(15),   4      Location     VARCHAR2(25),   5      CONSTRAINT Dept_name_ukey UNIQUE (Dept_Name,Location)); Table created. SQL> SQL> SQL> drop table department; Table dropped. SQL> SQL> --