Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / koti
Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
In support project one ticket alloted which steps follows manualy tell me ?
please send me forms, xml pulisher questions,answers
Explain oracle apps architecture.
What do you understand by soa?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What do you understand by a set of books?
What are do's and dont's of Interface?
Can you explain the difference between architecture followed in 10g & 11g?
What is the concept of soa governance?
tell my any difficult situtation you solved in your experience in your company?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What is a value set? List its various types.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How to move the one file from one instance to another instance? And your scripts also?
Do you know what is applysys in oracle application database schema, what is apps?