Sunday, 15 January 2012

php - I need help using the merge function with oracle -


I have three tables (partial_subs_2015, partial_reference and new subscribers), which include the customer's phone number and customer's name). Actually what I want to do, the number number in the load number and the customer name is partial_subs_new from partial_subs_2015, in a way that if those numbers are already present in partial_subs_2015, then nothing happens (update clause) and when These numbers are available in full_listers, they are removed from them Partial_subs_2015 (delete clause). And finally if the numbers are not found in partial_subs_2015 (no matches) in the partial_sub__ numbers, then they are inserted into that table (partial_subs_2015) (insert clause).

My query runs without indefinitely and I do not know why any kind of help would be appreciated. Actually this will give me a dynamic table so that customers will be fully converted, they have been removed from the partial_subs--2015 table. I have this question: merge into partial_subs_2015 on partial_subs_new E (e.customer_name = p.customer_name) when matching is done, remove update p.msisdn = p.msisdn where p Insert (MSIDN, Customer_N) Value (E.M.S.DN, E.C. Customer_Name)

in MSISDN (Choose MSISDN from Full_Subscriber) Html>

No comments:

Post a Comment