* 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 |
---|---|---|---|---|
89 | How-To Document / Change a Logo in a Page Template | admin | 2016.04.16 | 275 |
88 | VERY IMPORTANT | admin | 2018.06.26 | 272 |
87 | If you want to use EXISTS in a PL/SQL function returning BOOLEAN | admin | 2018.05.19 | 270 |
86 | eeeeee | admin | 2018.06.21 | 269 |
85 | Process | admin | 2018.05.05 | 266 |
84 | 3D Pie Chart | admin | 2016.05.17 | 263 |
83 | use a validation function for an element in apex 5.0 | admin | 2018.05.19 | 262 |
82 | MISSIONARY_SUB | admin | 2018.06.25 | 257 |
81 | All Data DELETE from Table | admin | 2018.05.10 | 257 |
80 | Name Show | admin | 2016.04.28 | 254 |
79 | How to convert DATE to NUMBER | admin | 2018.05.27 | 250 |
78 | TABLE PRINT | admin | 2018.06.18 | 243 |
77 | Captcha Test | admin | 2016.04.18 | 239 |
76 | IF/ELSE ... CASE WHEN | admin | 2018.06.25 | 233 |
75 | LAST DAY SQL | admin | 2024.01.19 | 230 |
74 | Using SQL*Plus to Unlock and Change Passwords | admin | 2023.06.04 | 230 |
73 | Null Display Value | admin | 2024.01.10 | 228 |
» | UPDATE PROCESS | admin | 2016.04.28 | 227 |
71 | EXPORT & IMPORT | admin | 2016.05.01 | 224 |
70 | Apex setup procedure | admin | 2016.04.28 | 224 |