Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between rollback & commit?
can a foreign key has null value?
- 6 Answers
- 14254 Views
- I also Faced
- E-Mail Answers
Answer Posted / anjani kumar
Commits and Rollback both complete our transaction cycle.
we use commit to store the DML changes into DB but Rollback
performs undo to our DML transaction
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Differentiate between pre-select and pre-query?
How to export data to a csv file?
Why do we use bulk collect in oracle?
How to start a new transaction in oracle?
How to drop an index in oracle?
Explain the use of ignore option in imp command.
How to call a sub procedure?
Explain the characteristics of oracle dba?
How do I learn what codesets are available in oracle?
Explain the difference between replace() and translate() functions in oracle?
What is oracle host variable?
is there a tool to trace queries, like profiler for sql server?
How to create a table index in oracle?
How to get maxsal , minsal, ename department wise in single query
