what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / ashu_deepu
rollback is used to revert back the changes which we have made in the databases.when we do the rollback we return back to the last commit point which we have made.
commit is use to make the changes in the databases permanently. the values of the variables are written to the databases or disk.
FK can have null value but primary key can't have null value.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are internal user account in oracle?
How to define and use table alias names in oracle?
List out the difference between commit, rollback, and savepoint?
can u plz provide me oca sql dumps please i need them
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How many types of synonyms in Oracle?
How to create a stored function in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
Explain the use of control file?
What is the oracle implicit cursor?
How to define a procedure inside another procedure?
Give the various rollback segment states.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Explain an integrity constrains?
What is the difference between online and offline backups?