| Welcome to [SHEPHARD FAMILY ENTERPRISE LLC]. We hope you enjoy your visit. You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. Join our community! If you're already a member please log in to your account to access all of our features: |
| Create a Procedure to Update a Table; Update using IF - THEN - ELSE | |
|---|---|
| Tweet Topic Started: Sep 7 2009, 07:34 PM (133 Views) | |
| shephardfamilyenterprise | Sep 7 2009, 07:34 PM Post #1 |
|
Administrator
![]() ![]() ![]() ![]() ![]()
|
CREATE OR REPLACE PROCEDURE OPERINIT IS hap_ar_customers.mb39action hap_ar_customers.mb39action%TYPE; BEGIN IF hap_ar_customers.mb39action is NOT NULL and hap_ar_customers.mb33grmcde||hap_ar_customers.mb39grgcde = ra_customers_interface.customer_number THEN Update ra_customers_interface set customer_attribute5 = (Select mb39grgaoi FROM hap_ar_customers WHERE mb39action is NOT NULL AND mb33grmcde||mb39grgcde = ra_customers_interface.customer_number); ELSE Update ra_customers_interface set customer_attribute5 = (select attribute5 from RA_CUSTOMERS where ra_customers.orig_system_reference = ra_customers_interface.orig_system_customer_ref); END IF; END OPERINIT; |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Oracle Financials Application · Next Topic » |





![]](http://z2.ifrm.com/static/1/pip_r.png)



3:49 AM Jul 11