How to restrict the duplicate records in table valuesets
- 2 Answers
- 6666 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows?
How do I limit the number of rows returned by an oracle query after ordering?
How to drop a tablespace?
What is the dynamic sql in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What is oracle server autotrace in oracle?
How to create a temporary table in oracle?
What is Virtual Private Database in Oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to turn on or off recycle bin for the session?
Difference between hot backup vs. Cold backup?
Can we save images in a database and if yes, how?
Where do we use decode and case statements?
What is oracle sid?
How to install oracle odbc drivers?
