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 the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

How do I audit the sql sent to the server?

0 Answers  

what is the main difference between join and subqurey?

3 Answers   Oracle,

Define implicit and explicit cursors.

0 Answers  

What is the difference between an inner and outer join?

0 Answers  

What are the indexing methods?

0 Answers  

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

Which one is faster ienumerable or iqueryable?

0 Answers  

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

how to start mysql server? : Sql dba

0 Answers  

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,