Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / rajesh
Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);
Regards
Rajesh...
If any queries..then fwd ...baburajeshd@gmail.com
| Is This Answer Correct ? | 91 Yes | 39 No |
Post New Answer View All Answers
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
how to print multi lay outs,muti currency,muti language in xml publisher
please send me forms, xml pulisher questions,answers
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What is oracle soa suite?
In hierarchical structure of a database? we have write query from where we should start?
List the various types of value set.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Explain what are the tables of auto invoice?
Can u give the Documentation of Custom.pll in oracle apps
Do you know what is applysys in oracle application database schema, what is apps?
How many schemas we have? how many you have used?
Explain oracle apps architecture.
what are the prerequisites for costing transactions?
Which oracle apps version you are very confident in?