BONUS DECIMAL(7,2) NOT NULL WITH DEFAULT 1000.00
CREATE TABLE EMPLOYEE ( ID SMALLINT NOT NULL, NAME VARCHAR(9) NOT NULL, DEPT SMALLINT, HIREDATE DATE NOT NULL WITH DEFAULT CURRENT_DATE, SALARY DECIMAL(7,2) NOT NULL DEFAULT 10000.00 );
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!