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

How to restrict the duplicate records in table valuesets

Question Posted / shalini gupta

Answer Posted / shalini gupta

we can create a unique index as well as primary key
constrains to restrict dulpicate record. unique key allows
one null but primary key constrains does not allow null.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

945

Please explain joins in oracle?

1007

How to convert characters to dates in oracle?

1021

How are extents allocated to a segment?

1057

What are nested tables?

1101

How many types of segments in Oracle?

1011

what are the advantages of running a database in archive log mode?

2139

How to display row numbers with the records?

1024

How to speed up webrick?

1004

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

974

How to best split csv strings in oracle 9i?

983

Explain the use of online redo log files in oracle.

990

Explain what are the characteristics of data files?

1029

what is the difference between restoring and recovering?

961

WHAT IS ecc 6.0

2098