Answer Posted / 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.
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
Can there be more than one function with a similar name in a pl/sql block?
What are different types of triggers?
What are the types of operators available in sql?
What is the difference between left outer join and left join?
How many types of relationship are there?
What is a unique constraint?
How to create your own reports in sql developer?
What is the sql query to display the current date?
What is rtm stands for?
What is sqlerrm?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Are dml statements autocommit?
What is ttitle and btitle?
How insert into statements in sql?
What is full form of rtm?
