|
select * from dept;
insert into DEPT (DEPTNO,DNAME,LOC) VALUES(66,'development','VIRGINIA')
insert into DEPT VALUES(77,'ELECTRICAL','VIRGINIA')
SELECT * FROM DEPT;
INSERT INTO EMP VALUES(7199,'GREEN','SALESMAN',7782,SYSDATE,2000,NULL,10);
SELECT * FROM EMP WHERE EMPNO=7199
INSERT INTO EMP VALUES(7186,'GREEN','SALESMAN',7782,TO_DATE('FEB 3,2012','MON DD,YYYY'),2000,NULL,10);
SELECT * FROM EMP WHERE EMPNO=7186
INSERT INTO dept (deptno, dname, loc)
VALUES (&department_id,'&department_name', '&location');
CREATE TABLE MANAGERS1 AS SELECT * FROM EMP WHERE JOB='TEST'
SELECT * FROM MANAGERS1
INSERT INTO MANAGERS1 (EMPNO,ENAME,SAL,HIREDATE) SELECT EMPNO,ENAME,SAL,HIREDATE FROM EMP WHERE JOB='MANAGER'
CREATE TABLE CLERK AS SELECT * FROM EMP WHERE JOB='CLERK'
SELECT * FROM CLERK
SELECT DEPTNO,EMPNO FROM EMP WHERE EMPNO=7782
UPDATE EMP SET DEPTNO=20 WHERE EMPNO=7782
UPDATE EMP SET (JOB,DEPTNO)=(SELECT JOB, DEPTNO FROM EMP WHERE EMPNO=7499) WHERE EMPNO=7698
SELECT JOB , DEPTNO FROM EMP WHERE EMPNO=7698
SELECT * FROM DEPT;
UPDATE EMP SET DEPTNO=55 WHERE DEPTNO=30
SELECT * FROM EMP
SELECT * FROM DEPT;
DELETE FROM DEPT WHERE DNAME='development'
delete from dept where dname='TRAINING'
DELETE FROM DEPT WHERE DEPTNO=60
ROLLBACK
SELECT * FROM DEPT;
ROLLBACK
DELETE FROM DEPT WHERE DEPTNO=66
COMMIT
SAVEPOINT A
SELECT * FROM DEPT
DELETE FROM DEPT WHERE DEPTNO=70
SAVEPOINT B
DELETE FROM DEPT WHERE DEPTNO=50
ROLLBACK B
SELECT * FROM EMP
DELETE FROM EMP
ROLLBACK
|
