today:
440
yesterday:
456
Total:
1,015,766

SQL INSERT PROCESS

admin 2016.04.28 13:27 Views : 169

* 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
126 YEAR EXPRESSIONS admin 2023.05.25 46
125 Global pages admin 2023.05.09 47
124 TEST admin 2023.05.03 49
123 GitHub.com/Oracle/APEX. admin 2023.05.04 50
122 ORACLE COLLECTION admin 2023.05.08 50
121 FINAL TEST admin 2023.05.08 51
120 DATE -> DAY CONVERT SQL admin 2023.05.25 52
119 TEST admin 2023.04.28 53
118 INNER JOIN admin 2023.05.19 53
117 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 54
116 Monthly SUM admin 2023.05.22 61
115 GP 영수증 (3) -01/04/2023 admin 2023.01.04 62
114 WHDR email address admin 2023.04.13 63
113 GP - 영수증 (2) admin 2022.11.07 67
112 GP 영수증 본문 admin 2022.11.07 70
111 LOOP TABLE UPDATE admin 2023.05.19 71
110 Building Mobile Applications with Oracle Application Express 5.0 admin 2017.11.25 72
109 CHANGE TABLE NAME admin 2023.05.31 72
108 ipconfig admin 2023.06.03 77
107 Manufacturing resource planning (MRP II) admin 2018.02.14 81