Std
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Std as PDF for free.
More details
- Words: 1,158
- Pages: 4
INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1011, 'SAMMY','SOSA', '732-7431124 ', '11,Marks Ln,Roseville', 'Hsmilton', 'NC'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1012, 'Ana','Baron', '123-4444444 ', '45 st. N', 'SANTACRUZ', 'CA'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1001, 'John','ADAMS','932678113 ', '125 st. E', 'Bronx', 'MH'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1002, 'SHERRY','SPIKE','124-564-2564', '67,Parkville st', 'New Castle', 'AL'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1003, 'JILL','TANG', '919-464-4572', '2 Freedom Avenue', 'Reading', 'NC'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1004, 'PAUL','CLUCK', '124-564-5678', '24,Northern freeway', 'SANTACRUZ', 'CA'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1005, 'VICTORIA','ENGLISH '816-752-3232', 'Dythlon Park, Suite#101', 'Los Angeles' , 'CA'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1006, 'SHERRY','LEE', '685-111-0000', '1,Menlo Park', 'SANTACRUZ', 'CA'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1013, 'UPS Inc.', '123456789 ', '230, Park Street', 'New York', 'MY'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1007, 'MARY','massy', '919-646-4896', '2,Fayetteville St.', 'Durham', 'NC'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1008, 'ALice','briggs', '865-477-2342', '31,Hudson Pkwy S', 'Chicago', 'IL'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1009, 'Jack','brown', '865-468-3322', '241,Medison Ave', 'Chicago', 'IL'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 1010, 'James','Haul', '9801235649 ', '66,Central Park,21 FRWY', 'Boston' , 'MA'); INSERT INTO CUSTOMER_MASTER ( CUST_ID, FIRST_NAME,LAST_NAME , PH_NO, ADDRESS, CITY, STATE ) VALUES ( 9999, 'Eva','Goody', '989898 ', 'Grand Central', 'NEW YORK', 'NY');
COMMIT; INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'web1', 'Quick Quote,PRO', 20000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'app1', 'FinancE DX V.2.2', 35000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'bpo1', 'Smart Call Monitor V.2.4', 12000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'bpo2', 'Smart Call Recorder V.3.0', 12500.5); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'app2', 'My CRM v.1.0', 52500.5); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'web2', 'Pay Safe V.2.0', 60000.5); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'ERP1', 'Black Belt v.2.0', 99000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'SAC1', 'TEST OUTER', 8500); COMMIT; INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 995, 1011, 'app1', 1, 35000, TO_Date( '01/25/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1000, 1001, 'app1', 1, 35000, TO_Date( '01/26/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1001, 1001, 'web1', 2, 40000, TO_Date( '02/06/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1002, 1002, 'bpo1', 2, 24000, TO_Date( '01/26/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1003, 1002, 'bpo2', 2, 25001, TO_Date( '01/27/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1004, 1002, 'app2', 1, 52500.5, TO_Date( '01/28/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1005, 1003, 'web2', 1, 60000.5, TO_Date( '01/28/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1006, 1004, 'app1', 2, 70000, TO_Date( '01/29/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1007, 1005, 'web1', 1, 20000, TO_Date( '01/29/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1014, 1002, 'bpo1', 2, 24000, TO_Date( '03/10/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'));
INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1008, 1007, 'app1', 1, 35000, TO_Date( '12/01/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1009, 1008, 'bpo1', 1, 12000, TO_Date( '11/10/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1010, 1008, 'bpo2', 1, 12500.5, TO_Date( '11/10/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1011, 1009, 'app2', 1, 52500.5, TO_Date( '07/15/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1012, 1010, 'bpo1', 2, 24000, TO_Date( '07/05/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1013, 1010, 'bpo2', 2, 25001, TO_Date( '07/05/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); COMMIT; INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 4721, 1007, 1008, 25000, TO_Date( '12/15/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 4511, 1008, 1009, 25000, TO_Date( '11/28/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 4512, 1008, 1010, 12000.5, TO_Date( '11/30/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 3210, 1009, 1011, 52500.5, TO_Date( '08/01/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 2875, 1010, 1012, 24000, TO_Date( '07/25/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5208, 1004, 1006, 10000, TO_Date( '03/09/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5201, 1001, 1000, 35000, TO_Date( '02/10/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5210, 1001, 1001, 40000, TO_Date( '02/21/2006 04:11:08 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5202, 1002, 1002, 12000, TO_Date( '02/10/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5203, 1002, 1003, 25001, TO_Date( '02/11/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5204, 1002, 1004, 30000.5, TO_Date( '02/12/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'));
INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5205, 1003, 1005, 45000.5, TO_Date( '02/12/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5206, 1004, 1006, 40000, TO_Date( '02/13/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5207, 1005, 1007, 20000, TO_Date( '02/13/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); COMMIT;
COMMIT; INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'web1', 'Quick Quote,PRO', 20000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'app1', 'FinancE DX V.2.2', 35000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'bpo1', 'Smart Call Monitor V.2.4', 12000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'bpo2', 'Smart Call Recorder V.3.0', 12500.5); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'app2', 'My CRM v.1.0', 52500.5); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'web2', 'Pay Safe V.2.0', 60000.5); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'ERP1', 'Black Belt v.2.0', 99000); INSERT INTO PRODUCT_MASTER ( PRODUCT_CD, PRODUCT_NAME, PRICE ) VALUES ( 'SAC1', 'TEST OUTER', 8500); COMMIT; INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 995, 1011, 'app1', 1, 35000, TO_Date( '01/25/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1000, 1001, 'app1', 1, 35000, TO_Date( '01/26/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1001, 1001, 'web1', 2, 40000, TO_Date( '02/06/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1002, 1002, 'bpo1', 2, 24000, TO_Date( '01/26/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1003, 1002, 'bpo2', 2, 25001, TO_Date( '01/27/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1004, 1002, 'app2', 1, 52500.5, TO_Date( '01/28/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1005, 1003, 'web2', 1, 60000.5, TO_Date( '01/28/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1006, 1004, 'app1', 2, 70000, TO_Date( '01/29/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1007, 1005, 'web1', 1, 20000, TO_Date( '01/29/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1014, 1002, 'bpo1', 2, 24000, TO_Date( '03/10/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'));
INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1008, 1007, 'app1', 1, 35000, TO_Date( '12/01/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1009, 1008, 'bpo1', 1, 12000, TO_Date( '11/10/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1010, 1008, 'bpo2', 1, 12500.5, TO_Date( '11/10/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1011, 1009, 'app2', 1, 52500.5, TO_Date( '07/15/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1012, 1010, 'bpo1', 2, 24000, TO_Date( '07/05/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO ORDER_TX ( ORD_ID, CUST_ID, PROD_CD, ORD_QTY, ORD_AMT, ORD_DT ) VALUES ( 1013, 1010, 'bpo2', 2, 25001, TO_Date( '07/05/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); COMMIT; INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 4721, 1007, 1008, 25000, TO_Date( '12/15/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 4511, 1008, 1009, 25000, TO_Date( '11/28/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 4512, 1008, 1010, 12000.5, TO_Date( '11/30/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 3210, 1009, 1011, 52500.5, TO_Date( '08/01/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 2875, 1010, 1012, 24000, TO_Date( '07/25/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5208, 1004, 1006, 10000, TO_Date( '03/09/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5201, 1001, 1000, 35000, TO_Date( '02/10/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5210, 1001, 1001, 40000, TO_Date( '02/21/2006 04:11:08 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5202, 1002, 1002, 12000, TO_Date( '02/10/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5203, 1002, 1003, 25001, TO_Date( '02/11/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5204, 1002, 1004, 30000.5, TO_Date( '02/12/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'));
INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5205, 1003, 1005, 45000.5, TO_Date( '02/12/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5206, 1004, 1006, 40000, TO_Date( '02/13/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO PAYMENT_TX ( PAY_ID, CUST_ID, ORD_ID, PAY_AMT, PAY_DT ) VALUES ( 5207, 1005, 1007, 20000, TO_Date( '02/13/2006 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); COMMIT;
Related Documents
Std
May 2020 25
Std
June 2020 20
01330-std
October 2019 44
Std Codes
November 2019 23
Std Capping
May 2020 20