How to restrict the duplicate records in table valuesets
Answer Posted / znaukak
Create unique key for this column where value should be
inserted.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What happens to the current transaction if the session is killed?
What is the difference between sharding and replication?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Is there a function to split a string in plsql?
What is the difference between count (*), count (expression), count (distinct expression)?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is the data pump import utility?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are the different editions of oracle?
What is program global area (pga) in oracle?
How to get a list of all background sessions in the database?
What is oracle latest version?
How to use "startup" command to start default instance?
What are the different types of failures that occur in Oracle database?