today:
7
yesterday:
158
Total:
1,001,261

SQL INSERT PROCESS

admin 2016.04.28 13:27 Views : 159

* INSERT PROCESS *
Begin


INSERT INTO DEMO_CUSTOMERS

(CUST_FIRST_NAME, CUST_LAST_NAME, CREDIT_LIMIT,NLS_TERRITORY,ACCOUNT_MGR_ID, CUST_EMAIL )

VALUES (:P9_CUST_FIRST_NAME, :P9_CUST_LAST_NAME, :P9_CREDIT_LIMIT,:P9_NLS_TERRITORY,
:P9_ACCOUNT_MGR_ID, :P9_CUST_EMAIL) ;

apex_application.g_print_success_message := '<center><span style = "font-weight:bold;     color:green;font-size: 12pt;" >
    Customer has been created 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  := '';


END;
No. Subject Author Date Views
26 EMPLOYEE_LEVEL_ID admin 2016.05.03 88
25 Link- AbbaBeauty admin 2018.02.13 85
24 Reversing Require HTTPS admin 2023.06.04 84
23 127.0.0.1:8080/apex/ admin 2023.06.03 83
22 STARTUP admin 2022.09.01 83
21 Apex Interactive Report: The difference between CIR and RIR admin 2018.01.26 81
20 Manufacturing resource planning (MRP II) admin 2018.02.14 78
19 ipconfig admin 2023.06.03 67
18 Building Mobile Applications with Oracle Application Express 5.0 admin 2017.11.25 64
17 GP - 영수증 (2) admin 2022.11.07 63
16 GP 영수증 본문 admin 2022.11.07 61
15 CHANGE TABLE NAME admin 2023.05.31 58
14 WHDR email address admin 2023.04.13 55
13 GP 영수증 (3) -01/04/2023 admin 2023.01.04 53
12 LOOP TABLE UPDATE admin 2023.05.19 50
11 FINAL TEST admin 2023.05.08 44
10 Global pages admin 2023.05.09 40
9 GitHub.com/Oracle/APEX. admin 2023.05.04 40
8 TEST admin 2023.04.28 40
7 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 39