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 many types of segments in Oracle?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Respected sir, Please send me technical questions related to oracle apps..
What privilege is needed for a user to delete rows from tables in another schema?
What are the uses of synonyms?
When do we use group by clause in a sql query?
can we insert any row to dual table if i got the permission from DBA
How to call a stored function with parameters?
Explain an index segment?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How do I know if oracle client is installed on windows?
What do you know about normalization? Explain in detail?