How to restrict the duplicate records in table valuesets
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
List the various oracle database objects?
How can we find out the current date and time in oracle?
what is the scenario where you take the database to NoArchivelog mode?
What is the data pump export utility?
What operating systems are supported by oracle database 10g xe?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How data locks are respected in oracle?
How to create a new table by selecting rows from another table?
What are the execution control statements?
Explain oracle insert into command?
How to write date and time literals in oracle?
How to create an oracle database manually?
Can we commit inside a function in oracle?
Why does oracle 9i treat an empty string as null?
What are a collation and state the different types of collation sensitivity?