What is Savepoint in Oracle SQL | Savepoint in Oracle SQL |Oracle tutorial in TAMIL

Описание: #oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers

Oracle SQL in Tamil - Day 1 -    • Day 1 - SQL in TAMIL | Oracle SQL tutorial...  

Oracle SQL in Tamil - Day 2 -    • Day 2 - SQL in TAMIL | Oracle SQL tutorial...  

Oracle SQL in Tamil - Day 3 -    • Day 3 - SQL in TAMIL | Oracle SQL tutorial...  

Oracle SQL in Tamil - Day 4 -    • Day 4 - SQL in TAMIL | Oracle SQL tutorial...  

Oracle SQL in Tamil - Day 5 -    • Day 5 - SQL in TAMIL | Oracle SQL tutorial...  

*******************************************************************************
For Training contact:
+91 7010080468

********************************************************************************
Join this channel to get access to perks:
   / @nicitacademy  

********************************************************************************
In this video, we’ll learn

A SAVEPOINT is a marker within a transaction that allows for a partial rollback.

As changes are made in a transaction, we can create SAVEPOINTs to mark different points within the transaction.

If we encounter an error, we can rollback to a SAVEPOINT or all the way back to the beginning of the transaction

Notes:

create table test (no1 number(3), no2 number(3));

insert into test values (1,2);
savepoint a;
insert into test values (3,4);
savepoint b;
insert into test values (5,6);
savepoint c;
insert into test values (7,8);

rollback to c;

select * from test;

rollback;

**********************************************************************************************

Oracle SAVEPOINT transactions (TCL Commands)
Savepoint, Rollback and Commit in Oracle
SQL: Savepoint (TCL Command)
SQL SAVEPOINT in Oracle Database
what is savepoint in oracle
Using Savepoint, Commit and Rollback in SQL
oracle sql tutorial for beginners
oracle sql tutorial in TAMIL
sql tutorial for beginners in tamil
sql tutorial for beginners
sql tutorial in tamil
how to create table in sql tamil
how to create table in oracle
sql in tamil
sql jobs in tamil
sql training in tamil
mysql in tamil
mysql install in tamil
sql interview questions and answers
sql interview questions and answers for freshers
sql joins with examples
sql joins interview questions
sql joins interview questions scenario based
sql joins interview questions and answers for experienced
sql joins interview questions and answers in tamil
SQL in Tamil
SQL interview questions and answers in Tamil

plsql tutorial oracle
pl sql videos in tamil
oracle pl sql tutorial in tamil
PL/SQL tutorial in tamil - Introduction
Oracle - Pl/SQL - Introduction
oracle pl sql tutorial in tamil
oracle pl sql full course
oracle pl sql real time projects
oracle real time scenarios
oracle pl sql tutorial for beginners
oracle pl sql interview questions
pl sql interview questions for 7 years experience
PL/SQL tutorial in tamil - Introduction


stored procedures in pl sql
stored procedures in pl sql with examples
stored procedure in pl sql developer
stored procedures sql in tamil
stored procedure in mysql in tamil
what is stored procedure in sql tamil
what is stored procedure in oracle
how to create stored procedure in sql
stored procedure in oracle
stored procedures sql in tamil
stored procedure vs function in sql server