Interested to Buy Any Domain ? << Click Here >> for more details...
How to restrict the duplicate records in table valuesets
- 2 Answers
- 7181 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 |
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Explain about achiever in sql?
What happens to the current transaction if the session is killed?
how will I find the first 5 highest salaried employees in each dept in oracle.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is the difference between RBBMS & DBMS?
Where do you use decode and case statements?
How can we delete duplicate rows in a table?
 What are the oracle DML commands possible through an update strategy?
How will you differentiate between varchar & varchar2?
Oracle General 
