![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
-- Populate CREDTIORS table
INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR)
VALUES (1, 'Citibank');
INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR)
VALUES (2, 'MBNA');
INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR)
VALUES (3, 'Discover');
INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR)
VALUES (4, 'Diners Club');
INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR)
VALUES (5, 'Bank of America');
INSERT INTO CREDITORS (CREDITOR_ID, CREDITOR)
VALUES (6, 'Capital One');
-- Populate DEBTORS table
INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME)
VALUES (1, 'John', 'Barnes');
INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME)
VALUES (2, 'Tony', 'Bernoulli');
INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME)
VALUES (3, 'Bobby', 'Sikes');
INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME)
VALUES (4, 'Jessica', 'Fox');
INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME)
VALUES (5, 'Linda', 'McHannel');
INSERT INTO DEBTORS (DEBTOR_ID, FIRST_NAME, LAST_NAME)
VALUES (6, 'Brandon', 'Crane');
-- Populate DEBTS table
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (1, 5, 1250.44, 1949.56);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (1, 6, 567.23, 3932.77);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (2, 1, 0.00, 2500.00);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (2, 3, 1809.87, 190.13);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (3, 1, 2000.00, 0.00);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (4, 4, 12.34, 587.66);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (4, 5, 224.56, 775.44);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (4, 1, 0.00, 4500.00);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (5, 2, 1870.23, 129.77);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (6, 2, 2301.10, 898.90);
INSERT INTO DEBTS (DEBTOR_ID, CREDITOR_ID, BALANCE, REMAINING_CREDIT)
VALUES (6, 3, 0.00, 3400.00);
commit;
|
The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.
All information submitted is secure.
The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.
Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.
All information submitted is secure.
My developerWorks:
My notifications:
The data melting pot
Building a business-to-business application with XML