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
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
default triggers available for reports
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
How would you determine who has added a row to a table?
what are basic modules required to implement oracle application in any oraganisation?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
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.
HOW TO SPOT AHIERARCHY?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What is autocashrule set? : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable