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 |
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is cardinality?
How would you force a log switch?
How do you use trigger to create mutating state of table
What is the difference between the SQL*Loader and IMPORT utilities?
How do you resize a data file?
Is it possible to drop a column in a table which contains only one column? How?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Can We Restore a Table that accidantly dropped.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?