today:
77
yesterday:
158
Total:
1,001,331

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 GP 영수증 본문 admin 2022.11.07 61
25 GP - 영수증 (2) admin 2022.11.07 63
24 GP 영수증 (3) -01/04/2023 admin 2023.01.04 53
23 TEST admin 2023.03.27 97
22 WHDR email address admin 2023.04.13 55
21 TEST admin 2023.04.28 40
20 TEST admin 2023.05.03 36
19 GitHub.com/Oracle/APEX. admin 2023.05.04 40
18 FINAL TEST admin 2023.05.08 44
17 ORACLE COLLECTION admin 2023.05.08 38
16 Global pages admin 2023.05.09 40
15 LOOP TABLE UPDATE admin 2023.05.19 50
14 INNER JOIN admin 2023.05.19 37
13 Monthly SUM admin 2023.05.22 37
12 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 39
11 YEAR EXPRESSIONS admin 2023.05.25 34
10 DATE -> DAY CONVERT SQL admin 2023.05.25 38
9 CHANGE TABLE NAME admin 2023.05.31 58
8 127.0.0.1:8080/apex/ admin 2023.06.03 83
7 ipconfig admin 2023.06.03 67