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
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
What is an Oracle database Full Backup?
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
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is autocashrule set? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
8. Supporting AP, AR and GL?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is the sql query to find the employee who has Nth maximum salary?
as a technical developer in oracle applications which type errors feced in your experience sofar
how to write customizations in po
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also