today:
144
yesterday:
148
Total:
999,280

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 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 108
25 wwv_flow_files admin 2016.05.01 147
24 EXPORT & IMPORT admin 2016.05.01 166
23 Outer Join with Oracle SQL admin 2016.04.29 147
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 220
21 Delimiter admin 2016.04.29 133
20 SQL SELECT DISTINCT Statement admin 2016.04.29 160
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 158
18 COUNT admin 2016.04.28 145
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 172
16 CREATE (INSERT) PROCESS admin 2016.04.28 150
15 DELETE PROCESS admin 2016.04.28 157
14 Global & Custom Serach file admin 2016.04.28 127
» INSERT PROCESS admin 2016.04.28 159
12 JAVA for delete admin 2016.04.28 154
11 LIST OF VALUE (DYNAMIC) admin 2016.04.28 126
10 MAX admin 2016.04.28 154
9 Name Show admin 2016.04.28 203
8 PHONE NUMBER admin 2016.04.28 152
7 UPDATE PROCESS admin 2016.04.28 167