Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210061 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 / priyranjan das
The basic differences between Primary Key and Unique key are as follows.
1) By default Primary Key will generate Clustured Index
whereas Unique Key will Generate Non-Clustured Index.
2) Primary Key is a combination of Unique and NOT NULL Constraints so it can’t
have duplicate values or any NUll
Whereas for Oracle UNIQUE Key can have any number of NULL whereas for SQL
Server It can have only one NULL
3) A table can have only one PK but It can have any number of UNIQUE Key.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is a cursor in oracle?
How many types of tables supported by oracle?
Why use resource manager in Oracle?
What is ceil and floor in oracle?
How to manage transaction isolation level?
Explain alias?
What are the differences between blob and clob in oracle?
Is postgres faster than oracle?
How do I recompile a procedure in oracle?
What is an Oracle Instance?
Explain oracle insert into command?
How to use group functions in the select clause using oracle?
When do we use group by clause in a sql query?
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.
Can select statements be used on views in oracle?
