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
- 2 Answers
- 6126 Views
- Syntel, I also Faced
- E-Mail Answers
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 different types of transactions in ar? : oracle accounts receivable
What is the mandatory setup in cyclecount ?
how to write customizations in po
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
What is an Oracle database Partial Backup?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance
What is auto invoicing? Explain : oracle accounts receivable
how to replace not in with not exist?
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Oracle General 
