UNIQUE CONSTRAINT

CREATE A TABLE

CREATE TABLE EMPLOYEE( EMPLOYEE_NUMBER DECIMAL(4,0), EMPLOYEE_FIRST_NAME VARCHAR2(50), );   ADDING Contrainsts to a Table During Creation Adding contrainsts to the entire table at creation in called an out of line constraint. That is because constraints are not added to individual columns. CREATE TABLE TBL_TRANSACTION2( AMOUNT NUMBER(15,2) NOT NULL, DATEOFTRANSACTION DATE NOT NULL, EMPLOYEENUMBER NUMBER(4,0) NOT

CREATE A TABLE Read More »

Scroll to Top