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 ADDM Advisor in Oracle?
Differentiate between TRUNCATE and DELETE?
what are the different types of cursors? explain?
Can multiple cursors being opened at the same time?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What is a cluster Key ?
what is the syntax of CREATE command?
What privilege is needed for a user to create indexes in oracle?
Explain table?
What happens if variable names collide with table/column names?
How do I uninstall oracle client from windows?
Explain the difference between replace() and translate() functions in oracle?