Answer / deva

Save points are used to mark our transactions. Then later
on, down the line, we can roll back to that particular
transaction and roll back can be issued to that particular
point.

Answer / bindhu

Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
SAVEPOINT statement.

Answer / tulsi

1)In savepoint we can only rollback to every point the
savepoint is issued but we cant do commit at every savepoint

Answer / rahul

used to recover data
that recently deleted

Answer / kotravel. b

To perform line by line transaction we r using save point

What is trigger in sql and its types?

0 Answers  

What is the order of sql select?

0 Answers  

What is data modelling in sql?

0 Answers  

Can we commit in trigger?

0 Answers  

What are the different dml commands in sql?

0 Answers  

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

Which command is used to call a stored procedure?

0 Answers  

What are the two types of exceptions in pl/sql?

0 Answers  

in procedure how to return a value

3 Answers   Wipro,

What are records give examples?

0 Answers  

What is foreign key sql?

0 Answers