In my table i'm having the duplicate records with sequence
number and my requirement is when in new record is coming i
want to delete existing old record(onlyone i.e maintaing the
partial duplicate date )and add new record
Answers were Sorted based on User's Feedback
Answer / premnathselvaraj
selet distinct column name
from table
| Is This Answer Correct ? | 5 Yes | 14 No |
A scenario for amount correction & how to use amount correction functionality in AP invoices
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Difference between negative and positive adjustments : oracle accounts receivable
How would you force a log switch?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
i have marks in table,how to find total?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Explain an ORA-01555
Give two examples of referential integrity constraints.