Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do sql triggers work?
What is numeric function sql?
What is on delete set null?
Why stored procedures are faster than query?
Explain the uses of a database trigger?
How many developers work on postgresql?
what are rollup and cube in t-sql? : Transact sql
what is normalization? : Sql dba
What is Histogram?
How delete all data from all tables in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the different types of a subquery?
How to move files from one directory to another in pl sql?
what is column? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
