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
- 4956 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / premnathselvaraj
selet distinct column name
from table
| Is This Answer Correct ? | 5 Yes | 14 No |
Post New Answer View All Answers
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what are basic modules required to implement oracle application in any oraganisation?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Is there any link between pr form(purchse requisition)and po form(purchase order)
what are the tools used for oracle 10g in real time.
key flexfield structure
Explain the payment term in ar. : oracle accounts receivable
What are different types of transactions in ar? : oracle accounts receivable
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
what is semphore explian it?
Differentiate between transaction type and transaction source? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
What is supporting issues GL AP and AR?
