Difference between primary key and unique key ?
Answer Posted / ajoy
primary key and unique key both can be referenced to other
table as foreign key. please check this error message
ORA-02270: no matching unique or primary key for this
column-list
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is a oracle database?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is snapshot is too old? Give and example for better understand.
How to count groups returned with the group by clause in oracle?
What is define in oracle?
What is an Oracle index?
How do you find current date and time in oracle?
What is the data type of dual table?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Explain an exception and its types?
What is connection pooling in oracle?
How different is ms access and oracle?
What are the general rules on data consistency?
How to do a full database export?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.