Tables and Data Script.pdf

Viewer
Transcript

Tables Creation/Modification for Demonstration Practice In this Course we have created user ‘PBTRAINING’ and some custom tables for practice purpose. If you wish to practice course demonstrations as it is, then please perform the following steps before you start demonstrations. User Creation : Log in as sys (sqlplus '/as sysdba') CREATE USER PBTRAINING identified by PBTRAINING; GRANT ALL PRIVILEGES to PBTRAINING;

Table Creation PBTRAINING.XXPB_CUSTOMERS: CREATE TABLE PBTRAINING.XXPB_CUSTOMERS ( CUSTOMER_ID NUMBER, FIRST_NAME VARCHAR2(50 BYTE), LAST_NAME VARCHAR2(50 BYTE), CUSTOMER_TYPE VARCHAR2(20 BYTE) FULL_NAME VARCHAR2(32 BYTE) STREET VARCHAR2(32 BYTE), CITY VARCHAR2(32 BYTE) STATE VARCHAR2(32 BYTE) ZIP VARCHAR2(10 BYTE), COUNTRY VARCHAR2(32 BYTE) MODIFIED_DATE DATE, WITNESS_ID NUMBER );

NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL,

ALTER TABLE PBTRAINING.XXPB_CUSTOMERS ADD ( CONSTRAINT GM_C1 PRIMARY KEY (CUSTOMER_ID));

Table Creation PBTRAINING.XXPB_ACCOUNT: CREATE TABLE PBTRAINING.XXPB_ACCOUNT ( ACCOUNT_ID NUMBER, BRANCH_ID NUMBER ACCOUNT_NUMBER VARCHAR2(20 BYTE) ACCOUNT_TYPE VARCHAR2(12 BYTE) BALANCE NUMBER MODIFIED_DATE DATE );

1 | Parallel Branch

NOT NULL, NOT NULL, NOT NULL, NOT NULL,

ALTER TABLE PBTRAINING.XXPB_ACCOUNT ADD ( CONSTRAINT GM_C3 PRIMARY KEY (ACCOUNT_ID));

Table Creation PBTRAINING.XXPB_BORROWER: CREATE TABLE PBTRAINING.XXPB_BORROWER ( CUSTOMER_ID NUMBER LOAN_ID NUMBER MODIFIED_DATE DATE );

NOT NULL, NOT NULL,

Table Creation PBTRAINING.XXPB_TRANSACTIONS: CREATE TABLE PBTRAINING.XXPB_TRANSACTIONS ( TRANSACTION_ID NUMBER, ACCOUNT_ID NUMBER, TRANSACTION_TYPE VARCHAR2(1 BYTE), AMOUNT NUMBER, MODIFIED_DATE DATE ); ALTER TABLE PBTRAINING.XXPB_TRANSACTIONS ADD ( CONSTRAINT GM_C4 PRIMARY KEY (TRANSACTION_ID));

Table Creation PBTRAINING.XXPB_LOAN: CREATE TABLE PBTRAINING.XXPB_LOAN ( LOAN_ID NUMBER, BRANCH_ID NUMBER LOAN_NUMBER VARCHAR2(20 BYTE) LOAN_TYPE VARCHAR2(30 BYTE) AMOUNT NUMBER MODIFIED_DATE DATE );

NOT NULL, NOT NULL, NOT NULL, NOT NULL,

Table Creation PBTRAINING.XXPB_DEPOSITOR: CREATE TABLE PBTRAINING.XXPB_DEPOSITOR ( CUSTOMER_ID NUMBER ACCOUNT_ID NUMBER MODIFIED_DATE DATE );

2 | Parallel Branch

NOT NULL, NOT NULL,

Table Creation PBTRAINING.XXPB_BRANCH: CREATE TABLE PBTRAINING.XXPB_BRANCH ( BRANCH_ID NUMBER, NAME VARCHAR2(32 BYTE), CITY VARCHAR2(32 BYTE), ASSESTS NUMBER, MODIFIED_DATE DATE ); ALTER TABLE PBTRAINING.XXPB_BRANCH ADD ( CONSTRAINT GM_C2 PRIMARY KEY (BRANCH_ID));

Table Creation PBTRAINING.XXPB_RANKING: CREATE TABLE PBTRAINING.XXPB_RANKING ( RANK_GROUP VARCHAR2(5 BYTE), MIN_AMOUNT NUMBER, MAX_AMOUNT NUMBER );

Foreign Key defining: alter table PBTRAINING.XXPB_BORROWER add constraint Cust_ID_FK foreign key (Customer_ID) references PBTRAINING.XXPB_CUSTOMERS(customer_id); alter table PBTRAINING.XXPB_TRANSACTIONS add constraint Acc_ID_FK foreign key (ACCOUNT_ID) references PBTRAINING. XXPB_ACCOUNT(ACCOUNT_ID); alter table PBTRAINING.XXPB_ACCOUNT add constraint Branch_ID_FK foreign key (BRANCH_ID) references PBTRAINING.XXPB_BRANCH(BRANCH_ID); alter table PBTRAINING.XXPB_DEPOSITOR add constraint DCust_ID_FK foreign key (Customer_ID) references PBTRAINING.XXPB_Customers(customer_id);

3 | Parallel Branch

Data Insertion: Insert Data into XXPB_CUSTOMERS : SET DEFINE OFF; Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (1, 'John', 'Smith', 'BUSINESS', 'John Smith', '1 Imaging Place', 'Tulsa', 'MN', '95113', 'US', TO_DATE('01/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, COUNTRY, MODIFIED_DATE) Values (2, 'Nelsenn', 'Tina', 'BUSINESS', 'Nelsenn Tina', '1151 Morton', 'Chattanooga', 'Kent', 'US', TO_DATE('05/10/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (3, 'Adamss', 'Jeff', 'PERSONAL', 'Adamss Jeff', '676 Whipple Ave.', 'Columbia', 'Pennsylvania', '55431', 'US', TO_DATE('02/11/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, COUNTRY, MODIFIED_DATE) Values (4, 'Bremerr', 'T.', 'BUSINESS', 'Bremerr T.', 'PO Box 34331', 'Brookline', 'MILANO', 'IT', TO_DATE('08/10/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE) Values (5, 'Hotchkisss', 'Zachary', 'PERSONAL', 'Hotchkisss Zachary', 'Molndalsvagen 101', 'SAN DIEGO', 'SAN DIEGO', '1970', 'US', TO_DATE('10/25/2004 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE) Values (6, 'Schillerr', 'Helmut', 'PERSONAL', 'Schillerr Helmut', '12323 Texas Avenue', 'ST PAUL', 'MICHIGAN', '10036', 'US', TO_DATE('12/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (8, 'Timmerr', 'A.', 'PERSONAL', 'Timmerr A.', '899 Greenhill Dr.', 'Kaiserslautern', 'MILANO', '94161', 'IT', TO_DATE('01/25/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3); Insert into PBTRAINING.XXPB_CUSTOMERS

4 | Parallel Branch

(CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (9, 'Malgowskii', 'Dirk', 'BUSINESS', 'Malgowskii Dirk', '123 Oak Park Blvd', 'London', 'London', 'UK', TO_DATE('07/09/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, COUNTRY, MODIFIED_DATE) Values (10, 'Hathawayy', 'Carolyn', 'BUSINESS', 'Hathawayy Carolyn', '100 Mytel Parkway', 'Sausalito', 'MICHIGAN', 'US', TO_DATE('05/31/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE) Values (11, 'Schneiderr', 'Uwe', 'PERSONAL', 'Schneiderr Uwe', '1344 3rd Street', 'Hillsborough', 'MICHIGAN', '10073', 'US', TO_DATE('04/22/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (12, 'LaPortee', 'Lisa', 'BUSINESS', 'LaPortee Lisa', '5 High Drive', 'La Crescenta', 'SHANGHAI', '721 80', 'CH', TO_DATE('01/25/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE) Values (13, 'Nick', 'Culkin', 'PERSONAL', 'Nick Culkin', '65 Y Street', 'Woodland Hills', 'SHANGHAI', '722 80', 'CH', TO_DATE('01/17/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE) Values (14, 'Paul', 'Rachubka', 'PERSONAL', 'Paul Rachubka', '300 La Selva', 'Memphis', 'SHANGHAI', '723 80', 'CH', TO_DATE('08/05/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, COUNTRY, MODIFIED_DATE) Values (15, 'Fabien', 'Barthez', 'BUSINESS', 'Fabien Barthez', 'Weena 646', 'NANTUCKET', 'Cordoba', 'AR', TO_DATE('05/25/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (16, 'Raimond', 'van der Gouw', 'PERSONAL', 'Raimond van der Gouw', '245 Oak Avenue', 'Aalst', 'Cordoba', '94132', 'AR', TO_DATE('12/23/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6);

5 | Parallel Branch

Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (17, 'Ricardo', 'RD', 'BUSINESS', 'Ricardo RD', '8 8TH AVENUE', 'Bologna', 'Cordoba', '94133', 'AR', TO_DATE('07/30/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (18, 'Roy', 'Carroll', 'BUSINESS', 'Roy Carroll', '500 Market Street', 'Sydney', 'Sydney', 'AU', TO_DATE('05/22/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (19, 'Andy', 'Goram', 'PERSONAL', 'Andy Goram', '1000 Smallman St', 'K¿ln', 'Cordoba', '11791', 'AR', TO_DATE('02/18/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1); Insert into PBTRAINING.XXPB_CUSTOMERS (CUSTOMER_ID, FIRST_NAME, LAST_NAME, CUSTOMER_TYPE, FULL_NAME, STREET, CITY, STATE, ZIP, COUNTRY, MODIFIED_DATE, WITNESS_ID) Values (20, 'Mark', 'Bosnich', 'PERSONAL', 'Mark Bosnich', '9034 Geary Boulevard', 'Aliso Viejo', 'Cordoba', '11792', 'AR', TO_DATE('06/21/2009 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10); COMMIT;

Insert Data into XXPB_BRANCH : SET DEFINE OFF; Insert into PBTRAINING.XXPB_BRANCH (BRANCH_ID, NAME, CITY, ASSESTS, MODIFIED_DATE) Values (1, 'Atlanta', 'Atlanta', 2000000, TO_DATE('10/25/2004 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BRANCH (BRANCH_ID, NAME, CITY, ASSESTS, MODIFIED_DATE) Values (2, 'Boston', 'Boston', 3000000, TO_DATE('07/22/2007 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BRANCH (BRANCH_ID, NAME, CITY, ASSESTS, MODIFIED_DATE) Values (3, 'California', 'California', 6000000, TO_DATE('12/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BRANCH (BRANCH_ID, NAME, CITY, ASSESTS, MODIFIED_DATE) Values (4, 'Texas', 'Texas', 4000000, TO_DATE('10/24/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BRANCH (BRANCH_ID, NAME, CITY, ASSESTS, MODIFIED_DATE)

6 | Parallel Branch

Values (5, 'Vegas', 'Vegas', 5000000, TO_DATE('06/25/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;

Insert Data into XXPB_ACCOUNT table : SET DEFINE OFF; Insert into PBTRAINING.XXPB_ACCOUNT (ACCOUNT_ID, BRANCH_ID, ACCOUNT_NUMBER, ACCOUNT_TYPE, BALANCE, MODIFIED_DATE) Values (1, 1, '1001', 'C', 2000, TO_DATE('10/19/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_ACCOUNT (ACCOUNT_ID, BRANCH_ID, ACCOUNT_NUMBER, ACCOUNT_TYPE, BALANCE, MODIFIED_DATE) Values (2, 1, '1002', 'C', 2000, TO_DATE('01/22/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_ACCOUNT (ACCOUNT_ID, BRANCH_ID, ACCOUNT_NUMBER, ACCOUNT_TYPE, BALANCE, MODIFIED_DATE) Values (3, 2, '1003', 'C', 3000, TO_DATE('12/08/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_ACCOUNT (ACCOUNT_ID, BRANCH_ID, ACCOUNT_NUMBER, ACCOUNT_TYPE, BALANCE, MODIFIED_DATE) Values (4, 3, '1004', 'S', 4000, TO_DATE('08/14/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_ACCOUNT (ACCOUNT_ID, BRANCH_ID, ACCOUNT_NUMBER, ACCOUNT_TYPE, BALANCE, MODIFIED_DATE) Values (5, 4, '1005', 'S', 6000, TO_DATE('06/25/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;

Insert Data into XXPB_BORROWER : SET DEFINE OFF; Insert into PBTRAINING.XXPB_BORROWER (CUSTOMER_ID, LOAN_ID, MODIFIED_DATE) Values (1, 1, TO_DATE('11/02/1974 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BORROWER (CUSTOMER_ID, LOAN_ID, MODIFIED_DATE) Values (2, 2, TO_DATE('05/06/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BORROWER (CUSTOMER_ID, LOAN_ID, MODIFIED_DATE) Values (5, 3, TO_DATE('06/05/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));

7 | Parallel Branch

Insert into PBTRAINING.XXPB_BORROWER (CUSTOMER_ID, LOAN_ID, MODIFIED_DATE) Values (6, 4, TO_DATE('05/16/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_BORROWER (CUSTOMER_ID, LOAN_ID, MODIFIED_DATE) Values (9, 5, TO_DATE('08/04/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;

Insert Data into XXPB_DEPOSITOR : SET DEFINE OFF; Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (1, 1, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (2, 2, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (3, 3, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (4, 4, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (5, 5, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (6, 1, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (8, 3, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (9, 4, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_DEPOSITOR (CUSTOMER_ID, ACCOUNT_ID, MODIFIED_DATE) Values (10, 5, TO_DATE('01/11/2013 16:30:33', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;

8 | Parallel Branch

Insert Data into XXPB_LOAN : SET DEFINE OFF; Insert into PBTRAINING.XXPB_LOAN (LOAN_ID, BRANCH_ID, LOAN_NUMBER, LOAN_TYPE, AMOUNT, MODIFIED_DATE) Values (1, 1, '1001', 'PERSONAL', 2000, TO_DATE('06/25/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_LOAN (LOAN_ID, BRANCH_ID, LOAN_NUMBER, LOAN_TYPE, AMOUNT, MODIFIED_DATE) Values (2, 1, '1002', 'HOME', 3000, TO_DATE('05/06/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_LOAN (LOAN_ID, BRANCH_ID, LOAN_NUMBER, LOAN_TYPE, AMOUNT, MODIFIED_DATE) Values (3, 2, '1003', 'CAR', 4000, TO_DATE('06/05/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_LOAN (LOAN_ID, BRANCH_ID, LOAN_NUMBER, LOAN_TYPE, AMOUNT, MODIFIED_DATE) Values (4, 3, '1004', 'PERSOAL', 5000, TO_DATE('12/12/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_LOAN (LOAN_ID, BRANCH_ID, LOAN_NUMBER, LOAN_TYPE, AMOUNT, MODIFIED_DATE) Values (5, 4, '1005', 'HOME', 6000, TO_DATE('03/16/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;

Insert Data into XXPB_RANKING: SET DEFINE OFF; Insert into PBTRAINING.XXPB_RANKING (RANK_GROUP, MIN_AMOUNT, MAX_AMOUNT) Values ('A', 25000, 100000); Insert into PBTRAINING.XXPB_RANKING (RANK_GROUP, MIN_AMOUNT, MAX_AMOUNT) Values ('B', 20000, 25000); Insert into PBTRAINING.XXPB_RANKING (RANK_GROUP, MIN_AMOUNT, MAX_AMOUNT) Values ('C', 15000, 20000); Insert into PBTRAINING.XXPB_RANKING (RANK_GROUP, MIN_AMOUNT, MAX_AMOUNT) Values ('D', 11000, 15000); COMMIT;

9 | Parallel Branch

Insert Data into XXPB_TRANSACTIONS: SET DEFINE OFF; Insert into PBTRAINING.XXPB_TRANSACTIONS (TRANSACTION_ID, ACCOUNT_ID, TRANSACTION_TYPE, AMOUNT, MODIFIED_DATE) Values (1, 1, 'D', 2000, TO_DATE('05/16/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_TRANSACTIONS (TRANSACTION_ID, ACCOUNT_ID, TRANSACTION_TYPE, AMOUNT, MODIFIED_DATE) Values (2, 2, 'C', 3000, TO_DATE('03/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_TRANSACTIONS (TRANSACTION_ID, ACCOUNT_ID, TRANSACTION_TYPE, AMOUNT, MODIFIED_DATE) Values (3, 3, 'D', 2000, TO_DATE('03/17/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_TRANSACTIONS (TRANSACTION_ID, ACCOUNT_ID, TRANSACTION_TYPE, AMOUNT, MODIFIED_DATE) Values (4, 4, 'C', 5000, TO_DATE('07/27/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into PBTRAINING.XXPB_TRANSACTIONS (TRANSACTION_ID, ACCOUNT_ID, TRANSACTION_TYPE, AMOUNT, MODIFIED_DATE) Values (5, 5, 'C', 4000, TO_DATE('07/05/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;

10 | Parallel Branch