what is the difference between rollback & commit?
can a foreign key has null value?
- 6 Answers
- 13356 Views
- I also Faced
- E-Mail Answers
Answer Posted / vaibhavi_dixit
With commit, all the changes, which are made using insert,
update or delete SQL statments, are save permanently in the
table(ie DB).Whereas, if one want to undo the changes made
by DML statments, then before issuing commit, one can use
rollback statment.Rollback statment has no effect, if used
after commit.
Yes foreign key can have null value.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is oracle database 10g express edition?
What are the common oracle dba tasks?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what is IDE,DMV in sql server?
State the difference between a primary key and foreign key?
what is meant by magic query
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to run the anonymous block again?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the sql query to concatenate column values from multiple rows in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What to do if dba lost the system password?
How to compare dates in oracle sql?
How to handle a single quote in oracle sql?
Explain the types of exception?
