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
what are the prerequisites for costing transactions?
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.
do you know is it possible to run the interface without using oracle apps?
What is a value set? List its various types.
What do you understand by concurrent programs?
What is the concept of soa governance?
How can you achieve loose coupling in soa framework?
is it possible to run the interface without using oracle apps?
In oracle application how do you debug or trace errors?
List the types of flexfield?
what is pay run id ?
In sequence i want to 11 and 15th values how we will write?
What do you understand by soa?
what is the differences between internal requisition and internal sales order?
how can i print random rows in plsql table