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

What is oracle soa suite and what are its different components?

1219

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

can we get profile values in report without using user exists is it possible how?

2884

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2266

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

2246

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2387

What are the Standard Reports and Forms in HRMS?

2319

What are the benefits of using soa architecture?

1252

how do you describe O2C along with tables

2773

How can a process be deployed in soa?

1270

Can you differentiate between mediator and osb?

1143

Explain what are the tables of auto invoice?

1142

what are the prerequisites for costing transactions?

3144

tell my any difficult situtation you solved in your experience in your company?

2319

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

1979