CREATE TABLE TBL(
EMP_ID NUMBER PRIMARY KEY,
NAME VARCHAR(20),
SALARY NUMBER NOT NULL,
CHECK (SALARY > 3000));
- ①10500
- ②11000
- ③11500
- ④16000
INSERT INTO TBL VALUES(1,'James',4000);
INSERT INTO TBL VALUES(2,'Andrew',6000);
INSERT INTO TBL VALUES(3,'Linda',7000);
DELETE FROM TBL WHERE EMP_ID=2;
UPDATE TBL SET SALARY=SALARY-500 WHERE EMP_ID=3;
UPDATE TBL SET SALARY=2000 WHERE EMP_ID=1;
INSERT INTO TBL VALUES(4,'Tom',5000);
INSERT INTO TBL VALUES(3,'Emma',8000);
UPDATE TBL SET SALARY=4500 WHERE EMP_ID=1;
DELETE FROM TBL WHERE EMP_ID=4;
SELECT SUM(SALARY) FROM TBL;