Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / samad
delete from emp a where rowid >(select min(rowid) from emp
b where a.rowid = b.rowid);
2. DELETE FROM EMP A
WHERE ROWID > ( SELECT min(ROWID) FROM EMP B WHERE
A.ROWID = B.ROWID)
cheers
samad
| Is This Answer Correct ? | 21 Yes | 18 No |
Post New Answer View All Answers
Can u give the Documentation of Custom.pll in oracle apps
What is a value set? List its various types.
In hierarchical structure of a database? we have write query from where we should start?
What are the different components of soa suite?
What are the Standard Reports and Forms in HRMS?
Is soa a part of oracle fusion middleware?
List the various types of value set.
How many schemas we have? how many you have used?
Do you know where we can check the status of po?
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 the difference between request group and request security in oracle apps?
How do you register report in oracle apps?
how can i print random rows in plsql table
can we get profile values in report without using user exists is it possible how?
what is pay run id ?