simple query step 1 select rowid,column1,column2,column3 from table name

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

Question Posted / satyan

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

Please Help Members By Posting Answers For Below Questions

How do you register report in oracle apps?

1040

What does appl_top directory contain?

1081

In oracle application how do you debug or trace errors?

1060

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3017

What are the different components of soa suite?

1150

How can you achieve loose coupling in soa framework?

1182

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2050

In hierarchical structure of a database? we have write query from where we should start?

2188

Do you know where we can check the status of po?

1205

Are you familiar with internet architecture of oracle apps 11i?

1022

Tell me how to debug the report?

1072

Can you define an erp system?

1102

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

1937

How many schemas we have? how many you have used?

2009

Can we create tables in apps schema?

1087