Interested to Buy Any Domain ? << Click Here >> for more details...
How to restrict the duplicate records in table valuesets
- 2 Answers
- 7307 Views
- IBM, I also Faced
- E-Mail Answers
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 Remove the 3rd highest salary person record from table?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is a synonym? What are its various types?
How can I introduce multiple conditions in like operator?
How to check the oracle tns settings?
how to hide the stored procedure inside a package
What is COST-based approach to optimization ?
What do you mean by cdb and pdb in oracle 12c?
how to produce numbers from 1 to 10 using dual table
what is host string in sql plus? how does it related to database?
What are the different types of failures that occur in Oracle database?
What is the function of Optimizer ?
Oracle General 
