Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Difference between primary key and unique key ?

Answer Posted / chintan desai

Primary key don't have any null value, each table have only
one primary key. Not support duplicate value.

Unique key is uniquely identify, more then one unique key
allow in table.

Here the main different is what primary key do not have any
null value where unique key have only one null value.

Ex: here t1 is the name of table which have two field id and
name. here id is identify as a unique key then unique key's
null value look like under bellow:

1 chintan
NULL komal
2 ck
NULL NULL

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5329


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370


What is a proxy object?

1063


how to do daily transactions with out sql* loader control file regesterd in apps?

1687


What are the oracle built-in data types?

1074


What is a private synonym?

1588


What is oracle host variable?

1065


Explain the difference between sql and oracle?

1079


How a database is related to tablespaces?

1032


what is port in oracle? how is it related to database application.

1949


What are internal user account in oracle?

1008


Use of an integrity constraint is better to validate data. Explain

1041


Why does oracle 9i treat an empty string as null?

1056


How to store pictures on to the database?

976


what is normalisation?what are its uses?

2273