TCL(TRNSACTION CONTROL LANGUAGE)
SAVEPOINT:
QUERY: 07
Q5. Write a query to implement the save point.
Syntax for save point:
SQL> SAVEPOINT <SAVE POINT NAME>;
QUERY: 07
SQL> SAVEPOINT S1;
Savepoint created.
SQL> SELECT * FROM EMP;
EMPNO ENAME DESIGNATIN SALARY
---------- ------------ - --------- ----------101 NAGARAJAN LECTURER 16000
102 SARAVANAN ASST. PROF 16000
104 CHINNI HOD, PROF 45000
SQL> INSERT INTO EMP VALUES(105,'PARTHASAR','STUDENT',100);
1 row created.
SQL> SELECT * FROM EMP;
EMPNO ENAME DESIGNATIN SALARY
----- ------------ ---------- ----------
105 PARTHASAR STUDENT 100
101 NAGARAJAN LECTURER 16000
102 SARAVANAN ASST. PROF 16000
104 CHINNI HOD, PROF 45000
ROLL BACK
QUERY: 08
Q5. Write a query to implement the Rollback.
Syntax for save point:
SQL> ROLL BACK <SAVE POINT NAME>;
QUERY: 08
SQL> ROLL BACK S1;
Rollback complete.
SQL> SELECT * FROM EMP;
EMPNO ENAME DESIGNATIN SALARY
---------- ------------ ---------- ----------
101 NAGARAJAN LECTURER 16000
102 SARAVANAN ASST. PROF 16000
103 PANNERSELVAM ASST. PROF 20000
104 CHINNI HOD, PROF 45000
COMMIT
QUERY: 09
Q5. Write a query to implement the Rollback.
Syntax for commit:
SQL> COMMIT;
QUERY: 09
SQL> COMMIT;
Commit complete.
****************************************************************************
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments