SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete from multiple tables

user263656Apr 1 2011 — edited Apr 1 2011

Hello guys,
Can somebody please help me. I want to delete this one transaction from all the below tables in my testing environment. Can somebody please help me with a script to do that? So basically I want a delete statement for the same select statement I have below.

 select distinct b.*
from ra_customer_trx_all a,
     ra_customer_trx_lines_all b,
     ra_cust_trx_line_salesreps_all c,
     ra_cust_trx_line_gl_dist_all d,
     ar_payment_schedules_all e 
where a.CUSTOMER_TRX_ID = b.CUSTOMER_TRX_ID
and b.CUSTOMER_TRX_ID = c.CUSTOMER_TRX_ID
and c.CUSTOMER_TRX_ID = d.CUSTOMER_TRX_ID
and d.CUSTOMER_TRX_ID = e.CUSTOMER_TRX_ID
and b.CUSTOMER_TRX_LINE_ID = d.CUSTOMER_TRX_LINE_ID
and a.customer_trx_id = 1328

Thanking you in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2011

Added on Apr 1 2011

6 comments

480 views