How to restrict the duplicate records in table valuesets
Answers were Sorted based on User's Feedback
Answer / znaukak
Create unique key for this column where value should be
inserted.
Is This Answer Correct ? | 12 Yes | 1 No |
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 |
how to produce numbers from 1 to 10 using dual table
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
what is Single Byte Overhead...?
what is meant by magic query
how to select second mauximum value in a given table under salary column
What is Parallel Server ?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
what is candidate key & super key
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How does Oracle guarantee data integrity of data changes?
Whats the benefit of dbms_stats over analyze?
What is a Sequence ?