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 THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is data file?
what is the difference between restoring and recovering?
What is OCI. What are its uses?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
Can group functions be mixed with non-group selection fields?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
How to export your own schema?
what is the exact diiference between DBMS and RDBMS
What is oracle and what are its different editions?
Difference between the “verify” and “feedback” command?
What is an Index ? How it is implemented in Oracle Database ?