today:
127
yesterday:
311
Total:
1,018,366

SQL UPDATE PROCESS

admin 2016.04.28 13:15 Views : 188

* 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 160
» UPDATE PROCESS admin 2016.04.28 188
39 PHONE NUMBER admin 2016.04.28 168
38 Name Show admin 2016.04.28 217
37 MAX admin 2016.04.28 174
36 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
35 INSERT PROCESS admin 2016.04.28 176
34 Global & Custom Serach file admin 2016.04.28 144
33 DELETE PROCESS admin 2016.04.28 180
32 CREATE (INSERT) PROCESS admin 2016.04.28 167
31 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
30 COUNT admin 2016.04.28 170
29 SQL SELECT DISTINCT Statement admin 2016.04.29 173
28 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
27 Outer Join with Oracle SQL admin 2016.04.29 155
26 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 150
25 EMPLOYEE_LEVEL_ID admin 2016.05.03 106
24 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 247
23 Display Value, Return Value admin 2016.05.10 139
22 CREATE VIEW admin 2016.05.13 241