How to restrict the duplicate records in table valuesets

Answers were Sorted based on User's Feedback



How to restrict the duplicate records in table valuesets..

Answer / znaukak

Create unique key for this column where value should be
inserted.

Is This Answer Correct ?    12 Yes 1 No

How to restrict the duplicate records in table valuesets..

Answer / 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

More Oracle General Interview Questions

How to test null values?

0 Answers  


Draw E-R diagram for many to many relationship ?

0 Answers   Keane India Ltd,


Give the advantages and disadvantages of clusters.

0 Answers  


What is the usage of analyze command in oracle?

0 Answers  


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

0 Answers  


3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,


what is dynamic SGA and static SGA

0 Answers   Oracle,


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

0 Answers  


what is the syntax of ALTER command?

8 Answers  


I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,


Is oracle a relational database?

0 Answers  


Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)