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

Answer Posted / premnathselvaraj

selet distinct column name
from table

Is This Answer Correct ?    5 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Tax Categories?

1632


What is the difference between recovery and restoring of the oracle database?

664


What is the difference between conversions and interfaces? : oracle accounts receivable

656


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1633


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1768






WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1500


What Are Cross Validation & Adi?

696


How would you determine who has added a row to a table?

1796


What is an Oracle database Partial Backup?

698


Could you please let me know the interfaces in OM / FA??

1740


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1638


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1703


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2025


What is the use of lockboxes? : oracle accounts receivable

659


what is semphore explian it?

2247