Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Answer Posted / satyan

simple query
step 1
select rowid,column1,column2,column3 from table name where
condition;
step 2
delete from table name where rowid = '........'

Is This Answer Correct ?    4 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the prerequisites for costing transactions?

2629


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.

2456


do you know is it possible to run the interface without using oracle apps?

642


What is a value set? List its various types.

647


What do you understand by concurrent programs?

613






What is the concept of soa governance?

762


How can you achieve loose coupling in soa framework?

713


is it possible to run the interface without using oracle apps?

1512


In oracle application how do you debug or trace errors?

628


List the types of flexfield?

598


what is pay run id ?

1705


In sequence i want to 11 and 15th values how we will write?

1568


What do you understand by soa?

684


what is the differences between internal requisition and internal sales order?

2149


how can i print random rows in plsql table

1928