today:
356
yesterday:
456
Total:
1,015,682

SQL INSERT PROCESS

admin 2016.04.28 13:27 Views : 168

* 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
66 Column Data 일괄 추가 admin 2023.11.24 168
65 SQL SELECT DISTINCT Statement admin 2016.04.29 170
64 JAVA for delete admin 2016.04.28 174
63 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 176
62 UPDATE PROCESS admin 2016.04.28 177
61 DELETE PROCESS admin 2016.04.28 177
60 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 178
59 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 180
58 EXPORT & IMPORT admin 2016.05.01 184
57 CREATE TABLESPACE admin 2016.04.28 188
56 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 188
55 Captcha Test file admin 2016.04.18 189
54 Apex setup procedure admin 2016.04.28 191
53 TABLE PRINT admin 2018.06.18 203
52 How to convert DATE to NUMBER admin 2018.05.27 209
51 Name Show admin 2016.04.28 213
50 MISSIONARY_SUB admin 2018.06.25 216
49 IF/ELSE ... CASE WHEN admin 2018.06.25 219
48 All Data DELETE from Table admin 2018.05.10 220
47 use a validation function for an element in apex 5.0 admin 2018.05.19 221