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 difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

What is pl sql code?

0 Answers  

How delete all records from table in sql?

0 Answers  

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

What are types of exception?

0 Answers  

What is difference between db2 and sql?

0 Answers  

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

Who developed sql?

0 Answers  

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

what are the advantages of cursors than procedures?

2 Answers