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 do you understand by soa?
What is oracle soa suite and what are its different components?
What is a value set? List its various types.
Tell me how to find the custom directory in front end?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Can we create tables in apps schema?
please send me forms, xml pulisher questions,answers
how can develope the po variance and po summary report? with tables mandatory columns and query please?
can we use look up type instead of a pofile option?or valueset?is it possible how?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What is a flexfield? List out its types.
What do you understand by concurrent programs?
Can you differentiate between mediator and osb?
Do you know where we can check the status of po?
How do you register report in oracle apps?