Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / venki_discussions
delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Do you know what is applysys in oracle application database schema, what is apps?
how to print multi lay outs,muti currency,muti language in xml publisher
can we get profile values in report without using user exists is it possible how?
What is the concept of soa governance?
List the types of flexfield?
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.
Tell me where we find the status of order information?
Tell me how to debug the report?
What are the different components of soa suite?
What do you understand by concurrent programs?
Which oracle apps version you are very confident in?
What is oracle soa suite?
What is sca and how is it useful?
Plz anybody send me Technical specification for AP Interface
How to create a purchase order without a requisition?