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 important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
i have marks in table,how to find total?
Can We Restore a Table that accidantly dropped.
What is the difference between recovery and restoring of the oracle database?
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
How do you switch from an init.ora file to a spfile?
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Can we modify approve purchase order?if yes what is navigation?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?