Skip to main content
Database Administrators

Return to Answer

format, padding
Source Link
edit approved Jan 7, 2019 at 7:09
peterh
edit approved Jan 7, 2019 at 7:09
peterh
  • 2.1k
  • 8
  • 28
  • 41

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

BEGIN SAVEPOINT ABC;
update table_A set column1 ='Y' where id = 69;

update table_A set column2 ='S' where id = 70;

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

 BEGIN
  SAVEPOINT ABC;  
  update table_A set column1 ='Y' where id = 69;

  update table_A set column2 ='S'  where id = 70; 

  EXCEPTION
  WHEN OTHERS THEN   
  ROLLBACK TO ABC;   
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

BEGIN SAVEPOINT ABC;
update table_A set column1 ='Y' where id = 69;

update table_A set column2 ='S' where id = 70;

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

 BEGIN
  SAVEPOINT ABC;  
  update table_A set column1 ='Y' where id = 69;

  update table_A set column2 ='S'  where id = 70; 

  EXCEPTION
  WHEN OTHERS THEN   
  ROLLBACK TO ABC;   
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.
deleted 14 characters in body
Source Link
Swati Gagare
Swati Gagare
  • 1
  • 1

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

BEGIN SAVEPOINT ABC;
update table_A set is_activecolumn1 ='Y' where config_idid = 69;

update table_A set createdon ='Y'column2 ='S' where config_idid = 70;

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

BEGIN SAVEPOINT ABC;
update table_A set is_active ='Y' where config_id = 69;

update table_A set createdon ='Y' where config_id = 70;

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

BEGIN SAVEPOINT ABC;
update table_A set column1 ='Y' where id = 69;

update table_A set column2 ='S' where id = 70;

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

added 4 characters in body
Source Link
Swati Gagare
Swati Gagare
  • 1
  • 1

--Rollback on Exception else Commit;   

--SET TRANSACTION READ WRITE; BEGIN

BEGIN SAVEPOINT ABC;
update table_A set is_active ='Y' where config_id = 69; update

update table_A set createdon ='Y' where config_id = 70; EXCEPTION

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT; END;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit;  --SET TRANSACTION READ WRITE; BEGIN SAVEPOINT ABC;
update table_A set is_active ='Y' where config_id = 69; update table_A set createdon ='Y' where config_id = 70; EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT; END;

--createdon is of datetime type and has an exception. So rollback will happen.

--Rollback on Exception else Commit; 

--SET TRANSACTION READ WRITE;

BEGIN SAVEPOINT ABC;
update table_A set is_active ='Y' where config_id = 69;

update table_A set createdon ='Y' where config_id = 70;

EXCEPTION WHEN OTHERS THEN
ROLLBACK TO ABC;
COMMIT;

END;

--createdon is of datetime type and has an exception. So rollback will happen.

Source Link
Swati Gagare
Swati Gagare
  • 1
  • 1