Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210270 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 / sunil upadhyay
the basic difference is that primary key can not have null
value whereas Unique key can have null values.two null
value are not same.One table may have more than one Unique
Key Constraint
columns, but should have only one Primary Key Constraint
column.
| Is This Answer Correct ? | 88 Yes | 51 No |
Post New Answer View All Answers
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.
What is meant by recursive hints in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is the difference between a user and a schema in oracle?
How a tablespace is related to data files?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to convert csv to table in oracle?
what are archived logs?
What are triggers in oracle?
How to calculate date and time differences in oracle?
What is oracle join syntax?
What is a database schema in oracle?
How to pass parameters to procedures?
What do you mean by merge in oracle?
What are the different windows events activated at runtime ?
