today:
149
yesterday:
311
Total:
1,018,388

SQL INSERT PROCESS

admin 2016.04.28 13:27 Views : 176

* 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 124
25 wwv_flow_files admin 2016.05.01 168
24 EXPORT & IMPORT admin 2016.05.01 191
23 Outer Join with Oracle SQL admin 2016.04.29 155
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
21 Delimiter admin 2016.04.29 148
20 SQL SELECT DISTINCT Statement admin 2016.04.29 173
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 179
18 COUNT admin 2016.04.28 170
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
16 CREATE (INSERT) PROCESS admin 2016.04.28 167
15 DELETE PROCESS admin 2016.04.28 180
14 Global & Custom Serach file admin 2016.04.28 144
» INSERT PROCESS admin 2016.04.28 176
12 JAVA for delete admin 2016.04.28 181
11 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
10 MAX admin 2016.04.28 174
9 Name Show admin 2016.04.28 217
8 PHONE NUMBER admin 2016.04.28 168
7 UPDATE PROCESS admin 2016.04.28 188