SQLize | PHPize | SQLtest

CREATE TABLE EMP ( EMPNO NUMBER PRIMARY KEY, ENAME VARCHAR2(50), DESIGNATION VARCHAR2(50), SALARY NUMBER ); INSERT INTO EMP VALUES (101, 'NAGARAJAN', 'LECTURER', 15000); SELECT * FROM EMP; SELECT * FROM EMP; UPDATE EMP SET SALARY = 16000 WHERE EMPNO = 101; SELECT * FROM EMP; UPDATE EMP SET SALARY = 16000, DESIGNATION = 'ASST.PROF' WHERE EMPNO = 102; SELECT * FROM EMP; DELETE FROM EMP WHERE EMPNO = 103; SELECT * FROM EMP; INSERT INTO EMP VALUES (171, 'saud', '&student23', &990); SAVEPOINT S1; SELECT * FROM EMP; INSERT INTO EMP VALUES (105, 'PARTHASAR', 'STUDEN5', 100); SELECT * FROM EMP; ROLLBACK TO S1; INSERT INTO EMP VALUES (183, 'test3', 'STUDENT14', 23); INSERT INTO EMP VALUES (1833, 'test34', 'STUDENT4', 231); INSERT INTO EMP VALUES (1831, 'test35', 'STUDENT2', 2325); SELECT * FROM EMP;