what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / aditi
commit save the transactions done after the last commit and rollback undo all transactions after last commit
Yes foreign key can have null value
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an oracle and why it is used?
How to use "while" statements in oracle?
Explain the use of record option in exp command.
How to define an anonymous procedure without variables?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is parameterized cursor in oracle?
How do I connect to oracle database?
What are the general rules on data consistency?
What are the various oracle database objects?
What is a nested table?
Why cursor variables are easier to use than cursors?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to create a new table in oracle?
How to apply filtering criteria at group level in oracle?
How to create tables for odbc connection testing?