what is the difference between rollback & commit?
can a foreign key has null value?
- 6 Answers
- 13270 Views
- I also Faced
- E-Mail Answers
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
How to assign a tablespace to a users in oracle?
What are the execution control statements in oracle?
What is oracle server autotrace in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How would you change old and new values in an insert, delete and update triggers?
How to write numeric literals in oracle?
How to pass parameters to procedures in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
what happened to the global index when I truncate the data in one of the partition?
what is meant by magic query
Explain the use of rows option in exp command.
What is rowid and rownum in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How a tablespace is related to data files?
