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 |
What is connection pool in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How many memory layers are in the shared pool?
When can Hash Cluster used ?
 How to use an oracle sequence generator in a mapping?
How to omit columns with default values in insert statement in oracle?
What is PL/SQL ?
How to use existing values in update statements using oracle?
Why do we use bulk collect in oracle?
various types of hints and their usage
How to convert csv to table in oracle?
Is there any function in oracle similar like group_concat of mysql?