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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Difference between primary key and unique key ?

Question Posted / austin johnson

Answer Posted / austin johnson

we can't insert a NULL value into to coloumn holding
primary key constrain.
where as we can insert a NULL value to a unique key feild.
Remember, both keys are used to identify the
rows/tuple/entry of the table uniquely.
so, only once u can enter a NULL value into the unique key
feild.

Is This Answer Correct ?    146 Yes 57 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blob data type in oracle?

1061

How to define an oracle sub procedure?

1076

What is a directory object?

1043

What is oracle rownum?

898

Does oracle partitioning improve performance?

959

How to connect to a local oracle 10g xe server?

952

What is an oracle wallet?

896

Explain an exception?

944

What is partitioned table in Oracle?

1129

How to test null values?

1055

Can we write dml statement in function in oracle?

1042

How to install oracle database 10g xe?

977

What happens if you lost a data file?

995

How do I know if oracle is installed on windows?

893

Give the constructs of a package, function or a procedure.

999