Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / pnr kiran
DELETE FROM TABLE E
WHERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is a value set? List its various types.
How is choreography different from orchestration?
What are do's and dont's of Interface?
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 does appl_top directory contain?
What are the different components of soa suite?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
how do you describe O2C along with tables
What are file in oracle.
do you know is it possible to run the interface without using oracle apps?
can we get profile values in report without using user exists is it possible how?
How to create a purchase order without a requisition?
q)what are the validations in sql*loader
What is oracle soa suite?
Can you define an erp system?