Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210088 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / chauhan rakesh botad
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Whats the benefit of dbms_stats over analyze?
How to assign query results to variables?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain what are the uses of rollback segment?
what is normalisation?what are its uses?
Can we save images in a database and if yes, how?
how to do daily transactions with out sql* loader control file regesterd in apps?
What are a cluster and non-cluster index?
What does sharding mean?
What is the best way to do multi-row insert 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 we delete duplicate rows in a table?
What is execute immediate in oracle?
What exactly do quotation marks around the table name do?
Is primary key indexed by default in oracle?
