I have 3 tables Acquirer_tbl , Advice_tbl,Txn_entry_Tbl . I have to update the table Txn_entry_Tbl setting column Acquire_Id value( from Acquirer_tbl) coresponding to Advice_Id. Advice Id has to be generated from Advicetbl w.r.t oprt_Id and feed_dt . I have to get Acquire_Id value from Acquirer_tbl grouping Oprtr_Id and Acqr_Id.
Please resolve this issue . I will be very Thankful..
I'm afraid to resolve your issue here would involve directing you to another forum - questions here are restricted to topics around SQL Developer. So we can teach you how the hammer works, but we can't come by your house and build you a deck.