When does a Transaction end ?
Answers were Sorted based on User's Feedback
Answer / kumar
Transaction ends with COMMIT or ROLLBACK keywords.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / bas
when ever commit or rollback statement occurred in the end
of trasaction
| Is This Answer Correct ? | 7 Yes | 2 No |
What are the arithmetic operations?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
How to use "if" statements on multiple conditions?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is a select query statement in oracle?
what is Single Byte Overhead...?
How to view the tablespaces in the current database?
Can objects of the same Schema reside in different tablespaces.?
Why required to run root.sh at the time of installation and what exactly it will do
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
How can you merge two tables in oracle?