today:
293
yesterday:
667
Total:
1,015,163

SQL UPDATE PROCESS

admin 2016.04.28 13:15 Views : 174

* UPDATE PROCESS *
begin

UPDATE DEMO_CUSTOMERS

SET
  CUST_FIRST_NAME = :P9_CUST_FIRST_NAME,
  CUST_LAST_NAME = :P9_CUST_LAST_NAME,
  CREDIT_LIMIT  = :P9_CREDIT_LIMIT,
  NLS_TERRITORY = :P9_NLS_TERRITORY,
  ACCOUNT_MGR_ID = :P9_ACCOUNT_MGR_ID,
CUST_EMAIL  =  :P9_CUST_EMAIL
 

WHERE CUSTOMER_ID  = :P9_CUSTOMER_ID;

apex_application.g_print_success_message := '<center><span style = "font-weight:bold;     color:green;font-size: 12pt;" >
    Customer has been updated to Table.</span></center>';

 
 :P9_CUST_FIRST_NAME := '';
 :P9_CUST_LAST_NAME := '';
 :P9_CREDIT_LIMIT:= '';
 :P9_NLS_TERRITORY:= '';
 :P9_ACCOUNT_MGR_ID := '';
:P9_CUST_EMAIL := '';

 Commit;
End;

No. Subject Author Date Views
41 Field Showing admin 2016.04.01 157
» UPDATE PROCESS admin 2016.04.28 174
39 PHONE NUMBER admin 2016.04.28 162
38 Name Show admin 2016.04.28 212
37 MAX admin 2016.04.28 164
36 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
35 INSERT PROCESS admin 2016.04.28 166
34 Global & Custom Serach file admin 2016.04.28 136
33 DELETE PROCESS admin 2016.04.28 176
32 CREATE (INSERT) PROCESS admin 2016.04.28 158
31 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 177
30 COUNT admin 2016.04.28 158
29 SQL SELECT DISTINCT Statement admin 2016.04.29 169
28 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 230
27 Outer Join with Oracle SQL admin 2016.04.29 154
26 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 141
25 EMPLOYEE_LEVEL_ID admin 2016.05.03 99
24 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 242
23 Display Value, Return Value admin 2016.05.10 132
22 CREATE VIEW admin 2016.05.13 233