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 |
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
default triggers available for reports
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
How would you determine the time zone under which a database was operating?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is database schema?
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)