Skip to content

Instantly share code, notes, and snippets.

@makubexD

makubexD/northwindDataInsert.sql

Created September 5, 2019 17:44
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save makubexD/343d21d1125f483e46b47ca3c66f23bf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save makubexD/343d21d1125f483e46b47ca3c66f23bf to your computer and use it in GitHub Desktop.
Download ZIP
northwind for oracle data (Insert to tables)
Raw
northwindDataInsert.sql
INSERT INTO northwind.customers (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments)
SELECT 1, 'Company A' , 'Bedecs' , 'Anna' , NULL, 'Owner' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 1st Street' , 'Seattle' , 'WA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 2, 'Company B' , 'Gratacos Solsona' , 'Antonio' , NULL, 'Owner' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 2nd Street' , 'Boston' , 'MA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 3, 'Company C' , 'Axen' , 'Thomas' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '123 3rd Street' , 'Los Angelas' , 'CA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 4, 'Company D' , 'Lee' , 'Christina' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 4th Street' , 'New York' , 'NY', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 5, 'Company E' , 'O’Donnell' , 'Martin' , NULL, 'Owner' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 5th Street' , 'Minneapolis' , 'MN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 6, 'Company F' , 'Pérez-Olaeta' , 'Francisco' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 7, 'Company G' , 'Xie' , 'Ming-Yang' , NULL, 'Owner' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 7th Street' , 'Boise' , 'ID', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 8, 'Company H' , 'Andersen' , 'Elizabeth' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 9, 'Company I' , 'Mortensen' , 'Sven' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 9th Street' , 'Salt Lake City', 'UT', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 10, 'Company J' , 'Wacker' , 'Roland' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 10th Street', 'Chicago' , 'IL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 11, 'Company K' , 'Krschne' , 'Peter' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 11th Street', 'Miami' , 'FL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 12, 'Company L' , 'Edwards' , 'John' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '123 12th Street', 'Las Vegas' , 'NV', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 13, 'Company M' , 'Ludick' , 'Andre' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 13th Street', 'Memphis' , 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 14, 'Company N' , 'Grilo' , 'Carlos' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 14th Street', 'Denver' , 'CO', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 15, 'Company O' , 'Kupkova' , 'Helena' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '456 15th Street', 'Honolulu' , 'HI', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 16, 'Company P' , 'Goldschmidt' , 'Daniel' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 16th Street', 'San Francisco' , 'CA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 17, 'Company Q' , 'Bagel' , 'Jean Philippe', NULL, 'Owner' , '(123)555-0100', NULL, NULL, '(123)555-0101', '456 17th Street', 'Seattle' , 'WA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 18, 'Company R' , 'Autier Miconi' , 'Catherine' , NULL, 'Purchasing Representative', '(123)555-0100', NULL, NULL, '(123)555-0101', '456 18th Street', 'Boston' , 'MA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 19, 'Company S' , 'Eggerer' , 'Alexander' , NULL, 'Accounting Assistant' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 19th Street', 'Los Angelas' , 'CA', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 20, 'Company T' , 'Li' , 'George' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 20th Street', 'New York' , 'NY', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 21, 'Company U' , 'Tham' , 'Bernard' , NULL, 'Accounting Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 21th Street', 'Minneapolis' , 'MN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 22, 'Company V' , 'Ramos' , 'Luciana' , NULL, 'Purchasing Assistant' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 22th Street', 'Milwaukee' , 'WI', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 23, 'Company W' , 'Entin' , 'Michael' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 23th Street', 'Portland' , 'OR', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 24, 'Company X' , 'Hasselberg' , 'Jonas' , NULL, 'Owner' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 24th Street', 'Salt Lake City', 'UT', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 25, 'Company Y' , 'Rodman' , 'John' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 25th Street', 'Chicago' , 'IL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 26, 'Company Z' , 'Liu' , 'Run' , NULL, 'Accounting Assistant' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 26th Street', 'Miami' , 'FL', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 27, 'Company AA', 'Toh' , 'Karen' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 27th Street', 'Las Vegas' , 'NV', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 28, 'Company BB', 'Raghav' , 'Amritansh' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 28th Street', 'Memphis' , 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 29, 'Company CC', 'Lee' , 'Soo Jung' , NULL, 'Purchasing Manager' , '(123)555-0100', NULL, NULL, '(123)555-0101', '789 29th Street', 'Denver' , 'CO', '99999', 'USA', NULL, NULL, '' FROM dual;
/* 'employees' */
INSERT INTO northwind.employees (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments)
SELECT 1, 'Northwind Traders', 'Freehafer', 'Nancy' , '[email protected]' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 1st Avenue', 'Seattle' , 'WA', '99999', 'USA', '#http://northwindtraders.com#', NULL, '' FROM dual UNION ALL
SELECT 2, 'Northwind Traders', 'Cencini' , 'Andrew' , '[email protected]' , 'Vice President, Sales', '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 2nd Avenue', 'Bellevue', 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales.', '' FROM dual UNION ALL
SELECT 3, 'Northwind Traders', 'Kotas' , 'Jan' , '[email protected]' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 3rd Avenue', 'Redmond' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Was hired as a sales associate and was promoted to sales representative.', '' FROM dual UNION ALL
SELECT 4, 'Northwind Traders', 'Sergienko', 'Mariya' , '[email protected]' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 4th Avenue', 'Kirkland', 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', NULL, '' FROM dual UNION ALL
SELECT 5, 'Northwind Traders', 'Thorpe' , 'Steven' , '[email protected]' , 'Sales Manager' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 5th Avenue', 'Seattle' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Joined the company as a sales representative and was promoted to sales manager. Fluent in French.', '' FROM dual UNION ALL
SELECT 6, 'Northwind Traders', 'Neipper' , 'Michael', '[email protected]', 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 6th Avenue', 'Redmond' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Fluent in Japanese and can read and write French, Portuguese, and Spanish.', '' FROM dual UNION ALL
SELECT 7, 'Northwind Traders', 'Zare' , 'Robert' , '[email protected]' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 7th Avenue', 'Seattle' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', NULL, '' FROM dual UNION ALL
SELECT 8, 'Northwind Traders', 'Giussani' , 'Laura' , '[email protected]' , 'Sales Coordinator' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 8th Avenue', 'Redmond' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Reads and writes French.', '' FROM dual UNION ALL
SELECT 9, 'Northwind Traders', 'Hellung-Larsen', 'Anne', '[email protected]' , 'Sales Representative' , '(123)555-0100', '(123)555-0102', NULL, '(123)555-0103', '123 9th Avenue', 'Seattle' , 'WA', '99999', 'USA', 'http://northwindtraders.com#http://northwindtraders.com/#', 'Fluent in French and German.', '' FROM dual;
/* products */
INSERT INTO northwind.products (supplier_ids, id, product_code, product_name, description, standard_cost, list_price, reorder_level, target_level, quantity_per_unit, discontinued, minimum_reorder_quantity, category, attachments)
SELECT '4' , 1 , 'NWTB-1' , 'Northwind Traders Chai' , NULL, 13.50, 18 , 10 , 40 , '10 boxes x 20 bags' , 0, 10 , 'Beverages' , '' FROM dual UNION ALL
SELECT '10', 3 , 'NWTCO-3' , 'Northwind Traders Syrup' , NULL, 7.50 , 10 , 25 , 100, '12 - 550 ml bottles', 0, 25 , 'Condiments', '' FROM dual UNION ALL
SELECT '10', 4 , 'NWTCO-4' , 'Northwind Traders Cajun Seasoning' , NULL, 16.5 , 22 , 10 , 40 , '48 - 6 oz jars' , 0, 10 , 'Condiments', '' FROM dual UNION ALL
SELECT '10', 5 , 'NWTO-5' , 'Northwind Traders Olive Oil' , NULL, 16.25, 21.35, 10 , 40 , '36 boxes' , 0, 10 , 'Oil' , '' FROM dual UNION ALL
SELECT '26', 6 , 'NWTJP-6' , 'Northwind Traders Boysenberry Spread', NULL, 18.75, 25 , 25 , 100, '12 - 8 oz jars' , 0, 25 , 'Jams, Preserves', '' FROM dual UNION ALL
SELECT '2' , 7 , 'NWTDFN-7' , 'Northwind Traders Dried Pears' , NULL, 22.50, 30 , 10 , 40 , '12 - 1 lb pkgs.' , 0, 10 , 'Dried Fruit & Nuts', '' FROM dual UNION ALL
SELECT '8' , 8 , 'NWTS-8' , 'Northwind Traders Curry Sauce' , NULL, 30 , 40 , 10 , 40 , '12 - 12 oz jars' , 0, 10 , 'Sauces' , '' FROM dual UNION ALL
SELECT '26', 14, 'NWTDFN-14', 'Northwind Traders Walnuts' , NULL, 17.75, 23.25, 10 , 40 , '40 - 100 g pkgs.' , 0, 10 , 'Dried Fruit & Nuts', '' FROM dual UNION ALL
SELECT '6' , 17, 'NWTCFV-17', 'Northwind Traders Fruit Cocktail' , NULL, 29.25, 39 , 10 , 40 , '15.25 OZ' , 0, 10 , 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '1' , 19, 'NWTBGM-19', 'Northwind Traders Chocolate Biscuits Mix', NULL, 6, 9.20 , 5 , 20 , '10 boxes x 12 pieces', 0, 5 , 'Baked Goods & Mixes', '' FROM dual UNION ALL
SELECT '26', 20, 'NWTJP-6' , 'Northwind Traders Marmalade' , NULL, 60.75, 81 , 10 , 40 , '30 gift boxes' , 0, 10 , 'Jams, Preserves', '' FROM dual UNION ALL
SELECT '1' , 21, 'NWTBGM-21', 'Northwind Traders Scones' , NULL, 7.50 , 10 , 5 , 20 , '24 pkgs. x 4 pieces', 0, 5 , 'Baked Goods & Mixes', '' FROM dual UNION ALL
SELECT '4' , 34, 'NWTB-34' , 'Northwind Traders Beer' , NULL, 10.50, 14 , 15 , 60 , '24 - 12 oz bottles' , 0, 15 , 'Beverages', '' FROM dual UNION ALL
SELECT '7' , 40, 'NWTCM-40' , 'Northwind Traders Crab Meat' , NULL, 13.80, 18.40, 30 , 120, '24 - 4 oz tins' , 0, 30 , 'Canned Meat', '' FROM dual UNION ALL
SELECT '6' , 41, 'NWTSO-41' , 'Northwind Traders Clam Chowder' , NULL, 7.75 , 9.65 , 10 , 40 , '12 - 12 oz cans' , 0, 10 , 'Soups', '' FROM dual UNION ALL
SELECT '34', 43, 'NWTB-43' , 'Northwind Traders Coffee' , NULL, 34.50, 46 , 25 , 100, '16 - 500 g tins' , 0, 25 , 'Beverages', '' FROM dual UNION ALL
SELECT '10', 48, 'NWTCA-48' , 'Northwind Traders Chocolate' , NULL, 9.25 , 12.75, 25 , 100, '10 pkgs' , 0, 25 , 'Candy', '' FROM dual UNION ALL
SELECT '2' , 51, 'NWTDFN-51', 'Northwind Traders Dried Apples' , NULL, 39.75, 53 , 10 , 40 , '50 - 300 g pkgs.' , 0, 10 , 'Dried Fruit & Nuts', '' FROM dual UNION ALL
SELECT '1' , 52, 'NWTG-52' , 'Northwind Traders Long Grain Rice' , NULL, 5.25 , 7 , 25 , 100, '16 - 2 kg boxes' , 0, 25 , 'Grains', '' FROM dual UNION ALL
SELECT '1' , 56, 'NWTP-56' , 'Northwind Traders Gnocchi' , NULL, 28.50, 38 , 30 , 120, '24 - 250 g pkgs.' , 0, 30 , 'Pasta', '' FROM dual UNION ALL
SELECT '1' , 57, 'NWTP-57' , 'Northwind Traders Ravioli' , NULL, 14.25, 19.50, 20 , 80 , '24 - 250 g pkgs.' , 0, 20 , 'Pasta', '' FROM dual UNION ALL
SELECT '8' , 65, 'NWTS-65' , 'Northwind Traders Hot Pepper Sauce' , NULL, 15.75, 21.05, 10 , 40 , '32 - 8 oz bottles' , 0, 10 , 'Sauces', '' FROM dual UNION ALL
SELECT '8' , 66, 'NWTS-66' , 'Northwind Traders Tomato Sauce' , NULL, 12.75, 17 , 20 , 80 , '24 - 8 oz jars' , 0, 20 , 'Sauces', '' FROM dual UNION ALL
SELECT '5' , 72, 'NWTD-72' , 'Northwind Traders Mozzarella' , NULL, 26.10, 34.8 , 10 , 40 , '24 - 200 g pkgs.' , 0, 10 , 'Dairy products', '' FROM dual UNION ALL
SELECT '26', 74, 'NWTDFN-74', 'Northwind Traders Almonds' , NULL, 7.50 , 10 , 5 , 20 , '5 kg pkg.' , 0, 5 , 'Dried Fruit & Nuts', '' FROM dual UNION ALL
SELECT '10', 77, 'NWTCO-77' , 'Northwind Traders Mustard' , NULL, 9.75 , 13 , 15 , 60 , '12 boxes' , 0, 15 , 'Condiments', '' FROM dual UNION ALL
SELECT '2' , 80, 'NWTDFN-80', 'Northwind Traders Dried Plums' , NULL, 3 , 3.50 , 50 , 75 , '1 lb bag' , 0, 25 , 'Dried Fruit & Nuts', '' FROM dual UNION ALL
SELECT '3' , 81, 'NWTB-81' , 'Northwind Traders Green Tea' , NULL, 2 , 2.99 , 100, 125, '20 bags per box' , 0, 25 , 'Beverages', '' FROM dual UNION ALL
SELECT '1' , 82, 'NWTC-82' , 'Northwind Traders Granola' , NULL, 2 , 4 , 20 , 100, NULL , 0, NULL, 'Cereal', '' FROM dual UNION ALL
SELECT '9' , 83, 'NWTCS-83' , 'Northwind Traders Potato Chips' , NULL, .50 , 1.80 , 30 , 200, NULL , 0, NULL, 'Chips, Snacks', '' FROM dual UNION ALL
SELECT '1' , 85, 'NWTBGM-85', 'Northwind Traders Brownie Mix' , NULL, 9 , 12.49, 10 , 20 , '3 boxes' , 0, 5 , 'Baked Goods & Mixes', '' FROM dual UNION ALL
SELECT '1' , 86, 'NWTBGM-86', 'Northwind Traders Cake Mix' , NULL, 10.50, 15.99, 10 , 20 , '4 boxes' , 0, 5 , 'Baked Goods & Mixes', '' FROM dual UNION ALL
SELECT '7' , 87, 'NWTB-87' , 'Northwind Traders Tea' , NULL, 2 , 40 , 20 , 50 , '100 count per box' , 0, NULL, 'Beverages', '' FROM dual UNION ALL
SELECT '6' , 88, 'NWTCFV-88', 'Northwind Traders Pears' , NULL, 1 , 1.3 , 10 , 40 , '15.25 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '6' , 89, 'NWTCFV-89', 'Northwind Traders Peaches' , NULL, 1 , 1.5 , 10 , 40 , '15.25 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '6' , 90, 'NWTCFV-90', 'Northwind Traders Pineapple' , NULL, 1 , 1.8 , 10 , 40 , '15.25 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '6' , 91, 'NWTCFV-91', 'Northwind Traders Cherry Pie Filling', NULL, 1 , 2 , 10 , 40 , '15.25 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '6' , 92, 'NWTCFV-92', 'Northwind Traders Green Beans' , NULL, 1 , 1.20 , 10 , 40 , '14.5 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '6' , 93, 'NWTCFV-93', 'Northwind Traders Corn' , NULL, 1 , 1.20 , 10 , 40 , '14.5 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '6' , 94, 'NWTCFV-94', 'Northwind Traders Peas' , NULL, 1 , 1.50 , 10 , 40 , '14.5 OZ' , 0, NULL, 'Canned Fruit & Vegetables', '' FROM dual UNION ALL
SELECT '7' , 95, 'NWTCM-95' , 'Northwind Traders Tuna Fish' , NULL, .50 , 2 , 30 , 50 , '5 oz' , 0, NULL, 'Canned Meat', '' FROM dual UNION ALL
SELECT '7' , 96, 'NWTCM-96' , 'Northwind Traders Smoked Salmon' , NULL, 2 , 4 , 30 , 50 , '5 oz' , 0, NULL, 'Canned Meat', '' FROM dual UNION ALL
SELECT '1' , 97, 'NWTC-82' , 'Northwind Traders Hot Cereal' , NULL, 3 , 5 , 50 , 200, NULL , 0, NULL, 'Cereal', '' FROM dual UNION ALL
SELECT '6' , 98, 'NWTSO-98' , 'Northwind Traders Vegetable Soup' , NULL, 1 , 1.89 , 100, 200, NULL , 0, NULL, 'Soups', '' FROM dual UNION ALL
SELECT '6' , 99, 'NWTSO-99' , 'Northwind Traders Chicken Soup' , NULL, 1 , 1.95 , 100, 200, NULL , 0, NULL, 'Soups', '' FROM dual;
/* suppliers */
INSERT INTO northwind.suppliers (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments)
SELECT 1, 'Supplier A', 'Andersen' , 'Elizabeth A.' , NULL, 'Sales Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 2, 'Supplier B', 'Weiler' , 'Cornelia' , NULL, 'Sales Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 3, 'Supplier C', 'Kelley' , 'Madeleine' , NULL, 'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 4, 'Supplier D', 'Sato' , 'Naoki' , NULL, 'Marketing Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 5, 'Supplier E', 'Hernandez-Echevarria','Amaya', NULL, 'Sales Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 6, 'Supplier F', 'Hayakawa' , 'Satomi' , NULL, 'Marketing Assistant' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 7, 'Supplier G', 'Glasson' , 'Stuart' , NULL, 'Marketing Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 8, 'Supplier H', 'Dunton' , 'Bryn Paul' , NULL, 'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 9, 'Supplier I', 'Sandberg' , 'Mikael' , NULL, 'Sales Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual UNION ALL
SELECT 10,'Supplier J', 'Sousa' , 'Luis' , NULL, 'Sales Manager' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '' FROM dual;
/* shippers */
INSERT INTO northwind.shippers (id, company, last_name, first_name, email_address, job_title, business_phone, home_phone, mobile_phone, fax_number, address, city, state_province, zip_postal_code, country_region, web_page, notes, attachments)
SELECT 1, 'Shipping Company A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123 Any Street', 'Memphis', 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 2, 'Shipping Company B', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123 Any Street', 'Memphis', 'TN', '99999', 'USA', NULL, NULL, '' FROM dual UNION ALL
SELECT 3, 'Shipping Company C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123 Any Street', 'Memphis', 'TN', '99999', 'USA', NULL, NULL, '' FROM dual;
/* inventory_transaction_types */
INSERT INTO northwind.inventory_transaction_types (id, type_name)
SELECT 1, 'Purchased' FROM dual UNION ALL
SELECT 2, 'Sold' FROM dual UNION ALL
SELECT 3, 'On Hold' FROM dual UNION ALL
SELECT 4, 'Waste' FROM dual;
/* order_details_status - None, Allocated, Invoiced,Shipped, On Order, No Stock */
INSERT INTO northwind.order_details_status (id, status_name)
SELECT 0, 'None' FROM dual UNION ALL
SELECT 1, 'Allocated' FROM dual UNION ALL
SELECT 2, 'Invoiced' FROM dual UNION ALL
SELECT 3, 'Shipped' FROM dual UNION ALL
SELECT 4, 'On Order' FROM dual UNION ALL
SELECT 5, 'No Stock' FROM dual;
/* orders_status' - New, Invoiced, Shipped, Closed */
INSERT INTO northwind.orders_status (id, status_name)
SELECT 0, 'New' FROM dual UNION ALL
SELECT 1, 'Invoiced' FROM dual UNION ALL
SELECT 2, 'Shipped' FROM dual UNION ALL
SELECT 3, 'Closed' FROM dual;
/* orders_tax_status */
INSERT INTO northwind.orders_tax_status (id, tax_status_name)
SELECT 0, 'Tax Exempt' FROM dual UNION ALL
SELECT 1, 'Taxable' FROM dual;
/* purchase_order_status */
INSERT INTO northwind.purchase_order_status (id, status)
SELECT 0, 'New' FROM dual UNION ALL
SELECT 1, 'Submitted' FROM dual UNION ALL
SELECT 2, 'Approved' FROM dual UNION ALL
SELECT 3, 'Closed' FROM dual;
/* orders */
INSERT INTO northwind.orders (id, employee_id, customer_id, order_date, shipped_date, shipper_id, ship_name, ship_address, ship_city, ship_state_province, ship_zip_postal_code, ship_country_region, shipping_fee, taxes, payment_type, paid_date, notes, tax_rate, tax_status_id, status_id)
SELECT 30, 9, 27, to_timestamp('2006-01-15', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, 'Karen Toh' , '789 27th Street', 'Las Vegas' , 'NV', '99999', 'USA', 200, 0, 'Check' , to_timestamp('2006-01-15', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 31, 3, 4 , to_timestamp('2006-01-20', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 'Christina Lee' , '123 4th Street' , 'New York' , 'NY', '99999', 'USA', 5 , 0, 'Credit Card', to_timestamp('2006-01-20', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 32, 4, 12, to_timestamp('2006-01-22', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, 'John Edwards' , '123 12th Street', 'Las Vegas' , 'NV', '99999', 'USA', 5 , 0, 'Credit Card', to_timestamp('2006-01-22', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 33, 6, 8 , to_timestamp('2006-01-30', 'YY-MM-DD'), to_timestamp('2006-01-31', 'YY-MM-DD'), 3, 'Elizabeth Andersen' , '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', 50 , 0, 'Credit Card', to_timestamp('2006-01-30', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 34, 9, 4 , to_timestamp('2006-02-06', 'YY-MM-DD'), to_timestamp('2006-02-07', 'YY-MM-DD'), 3, 'Christina Lee' , '123 4th Street' , 'New York' , 'NY', '99999', 'USA', 4 , 0, 'Check' , to_timestamp('2006-02-06', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 35, 3, 29, to_timestamp('2006-02-10', 'YY-MM-DD'), to_timestamp('2006-02-12', 'YY-MM-DD'), 2, 'Soo Jung Lee' , '789 29th Street', 'Denver' , 'CO', '99999', 'USA', 7 , 0, 'Check' , to_timestamp('2006-02-10', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 36, 4, 3 , to_timestamp('2006-02-23', 'YY-MM-DD'), to_timestamp('2006-02-25', 'YY-MM-DD'), 2, 'Thomas Axen' , '123 3rd Street' , 'Los Angelas' , 'CA', '99999', 'USA', 7 , 0, 'Cash' , to_timestamp('2006-02-23', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 37, 8, 6 , to_timestamp('2006-03-06', 'YY-MM-DD'), to_timestamp('2006-03-09', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', 12 , 0, 'Credit Card', to_timestamp('2006-03-06', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 38, 9, 28, to_timestamp('2006-03-10', 'YY-MM-DD'), to_timestamp('2006-03-11', 'YY-MM-DD'), 3, 'Amritansh Raghav' , '789 28th Street', 'Memphis' , 'TN', '99999', 'USA', 10 , 0, 'Check' , to_timestamp('2006-03-10', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 39, 3, 8 , to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 3, 'Elizabeth Andersen' , '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', 5 , 0, 'Check' , to_timestamp('2006-03-22', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 40, 4, 10, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, 'Roland Wacker' , '123 10th Street', 'Chicago' , 'IL', '99999', 'USA', 9 , 0, 'Credit Card', to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 41, 1, 7 , to_timestamp('2006-03-24', 'YY-MM-DD'), NULL , NULL, 'Ming-Yang Xie' , '123 7th Street' , 'Boise' , 'ID', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 42, 1, 10, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-07', 'YY-MM-DD'), 1, 'Roland Wacker' , '123 10th Street', 'Chicago' , 'IL', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 2 FROM dual UNION ALL
SELECT 43, 1, 11, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL , 3, 'Peter Krschne' , '123 11th Street', 'Miami' , 'FL', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 44, 1, 1 , to_timestamp('2006-03-24', 'YY-MM-DD'), NULL , NULL, 'Anna Bedecs' , '123 1st Street' , 'Seattle' , 'WA', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 45, 1, 28, to_timestamp('2006-04-07', 'YY-MM-DD'), to_timestamp('2006-04-07', 'YY-MM-DD'), 3, 'Amritansh Raghav' , '789 28th Street', 'Memphis' , 'TN', '99999', 'USA', 40 , 0, 'Credit Card', to_timestamp('2006-04-07', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 46, 7, 9 , to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 'Sven Mortensen' , '123 9th Street' , 'Salt Lake City', 'UT', '99999', 'USA', 100, 0, 'Check' , to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 47, 6, 6 , to_timestamp('2006-04-08', 'YY-MM-DD'), to_timestamp('2006-04-08', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', 300, 0, 'Credit Card', to_timestamp('2006-04-08', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 48, 4, 8 , to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 2, 'Elizabeth Andersen' , '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', 50 , 0, 'Check' , to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 50, 9, 25, to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 'John Rodman' , '789 25th Street', 'Chicago' , 'IL', '99999', 'USA', 5 , 0, 'Cash', to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 51, 9, 26, to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 3, 'Run Liu' , '789 26th Street', 'Miami' , 'FL', '99999', 'USA', 60 , 0, 'Credit Card', to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 55, 1, 29, to_timestamp('2006-04-05', 'YY-MM-DD'), to_timestamp('2006-04-05', 'YY-MM-DD'), 2, 'Soo Jung Lee' , '789 29th Street', 'Denver' , 'CO', '99999', 'USA', 200, 0, 'Check' , to_timestamp('2006-04-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 56, 2, 6 , to_timestamp('2006-04-03', 'YY-MM-DD'), to_timestamp('2006-04-03', 'YY-MM-DD'), 3, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', 0 , 0, 'Check' , to_timestamp('2006-04-03', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 57, 9, 27, to_timestamp('2006-04-22', 'YY-MM-DD'), to_timestamp('2006-04-22', 'YY-MM-DD'), 2, 'Karen Toh' , '789 27th Street', 'Las Vegas' , 'NV', '99999', 'USA', 200, 0, 'Check' , to_timestamp('2006-04-22', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 58, 3, 4 , to_timestamp('2006-04-22', 'YY-MM-DD'), to_timestamp('2006-04-22', 'YY-MM-DD'), 1, 'Christina Lee' , '123 4th Street' , 'New York' , 'NY', '99999', 'USA', 5 , 0, 'Credit Card', to_timestamp('2006-04-22', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 59, 4, 12, to_timestamp('2006-04-22', 'YY-MM-DD'), to_timestamp('2006-04-22', 'YY-MM-DD'), 2, 'John Edwards' , '123 12th Street', 'Las Vegas' , 'NV', '99999', 'USA', 5 , 0, 'Credit Card', to_timestamp('2006-04-22', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 60, 6, 8 , to_timestamp('2006-04-30', 'YY-MM-DD'), to_timestamp('2006-04-30', 'YY-MM-DD'), 3, 'Elizabeth Andersen' , '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', 50 , 0, 'Credit Card', to_timestamp('2006-04-30', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 61, 9, 4 , to_timestamp('2006-04-07', 'YY-MM-DD'), to_timestamp('2006-04-07', 'YY-MM-DD'), 3, 'Christina Lee' , '123 4th Street' , 'New York' , 'NY', '99999', 'USA', 4 , 0, 'Check' , to_timestamp('2006-04-07', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 62, 3, 29, to_timestamp('2006-04-12', 'YY-MM-DD'), to_timestamp('2006-04-12', 'YY-MM-DD'), 2, 'Soo Jung Lee' , '789 29th Street', 'Denver' , 'CO', '99999', 'USA', 7 , 0, 'Check' , to_timestamp('2006-04-12', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 63, 4, 3 , to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, 'Thomas Axen' , '123 3rd Street' , 'Los Angelas' , 'CA', '99999', 'USA', 7 , 0, 'Cash', to_timestamp('2006-04-25', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 64, 8, 6 , to_timestamp('2006-05-09', 'YY-MM-DD'), to_timestamp('2006-05-09', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', 12 , 0, 'Credit Card', to_timestamp('2006-05-09', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 65, 9, 28, to_timestamp('2006-05-11', 'YY-MM-DD'), to_timestamp('2006-05-11', 'YY-MM-DD'), 3, 'Amritansh Raghav' , '789 28th Street', 'Memphis' , 'TN', '99999', 'USA', 10 , 0, 'Check' , to_timestamp('2006-05-11', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 66, 3, 8 , to_timestamp('2006-05-24', 'YY-MM-DD'), to_timestamp('2006-05-24', 'YY-MM-DD'), 3, 'Elizabeth Andersen' , '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', 5 , 0, 'Check' , to_timestamp('2006-05-24', 'YY-MM-DD'), NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 67, 4, 10, to_timestamp('2006-05-24', 'YY-MM-DD'), to_timestamp('2006-05-24', 'YY-MM-DD'), 2, 'Roland Wacker' , '123 10th Street', 'Chicago' , 'IL', '99999', 'USA', 9 , 0, 'Credit Card', to_timestamp('2006-05-24', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 68, 1, 7 , to_timestamp('2006-05-24', 'YY-MM-DD'), NULL , NULL, 'Ming-Yang Xie' , '123 7th Street' , 'Boise' , 'ID', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 69, 1, 10, to_timestamp('2006-05-24', 'YY-MM-DD'), NULL , 1, 'Roland Wacker' , '123 10th Street', 'Chicago' , 'IL', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 70, 1, 11, to_timestamp('2006-05-24', 'YY-MM-DD'), NULL , 3, 'Peter Krschne' , '123 11th Street', 'Miami' , 'FL', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 71, 1, 1 , to_timestamp('2006-05-24', 'YY-MM-DD'), NULL , 3, 'Anna Bedecs' , '123 1st Street' , 'Seattle' , 'WA', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 72, 1, 28, to_timestamp('2006-06-07', 'YY-MM-DD'), to_timestamp('2006-06-07', 'YY-MM-DD'), 3, 'Amritansh Raghav' , '789 28th Street', 'Memphis' , 'TN', '99999', 'USA', 40 , 0, 'Credit Card', to_timestamp('2006-06-07', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 73, 7, 9 , to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 1, 'Sven Mortensen' , '123 9th Street' , 'Salt Lake City', 'UT', '99999', 'USA', 100, 0, 'Check' , to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 74, 6, 6 , to_timestamp('2006-06-08', 'YY-MM-DD'), to_timestamp('2006-06-08', 'YY-MM-DD'), 2, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', 300, 0, 'Credit Card', to_timestamp('2006-06-08', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 75, 4, 8 , to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 2, 'Elizabeth Andersen' , '123 8th Street' , 'Portland' , 'OR', '99999', 'USA', 50 , 0, 'Check' , to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 76, 9, 25, to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 1, 'John Rodman' , '789 25th Street', 'Chicago' , 'IL', '99999', 'USA', 5 , 0, 'Cash', to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 77, 9, 26, to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 3, 'Run Liu' , '789 26th Street', 'Miami' , 'FL', '99999', 'USA', 60 , 0, 'Credit Card', to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 78, 1, 29, to_timestamp('2006-06-05', 'YY-MM-DD'), to_timestamp('2006-06-05', 'YY-MM-DD'), 2, 'Soo Jung Lee' , '789 29th Street', 'Denver' , 'CO', '99999', 'USA', 200, 0, 'Check' , to_timestamp('2006-06-05', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 79, 2, 6 , to_timestamp('2006-06-23', 'YY-MM-DD'), to_timestamp('2006-06-23', 'YY-MM-DD'), 3, 'Francisco Pérez-Olaeta', '123 6th Street' , 'Milwaukee' , 'WI', '99999', 'USA', 0 , 0, 'Check' , to_timestamp('2006-06-23', 'YY-MM-DD'), NULL, 0, NULL, 3 FROM dual UNION ALL
SELECT 80, 2, 4 , to_timestamp('2006-04-25', 'YY-MM-DD'), NULL , NULL, 'Christina Lee' , '123 4th Street' , 'New York' , 'NY', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual UNION ALL
SELECT 81, 2, 3 , to_timestamp('2006-04-25', 'YY-MM-DD'), NULL , NULL, 'Thomas Axen' , '123 3rd Street' , 'Los Angelas' , 'CA', '99999', 'USA', 0 , 0, NULL, NULL, NULL, 0, NULL, 0 FROM dual;
/* order_details */
INSERT INTO northwind.order_details (id, order_id, product_id, quantity, unit_price, discount, status_id, date_allocated, purchase_order_id, inventory_id)
SELECT 27, 30, 34, 100, 14 , 0, 2, NULL, 96 , 83 FROM dual UNION ALL
SELECT 28, 30, 80, 30 , 3.5 , 0, 2, NULL, NULL, 63 FROM dual UNION ALL
SELECT 29, 31, 7 , 10 , 30 , 0, 2, NULL, NULL, 64 FROM dual UNION ALL
SELECT 30, 31, 51, 10 , 53 , 0, 2, NULL, NULL, 65 FROM dual UNION ALL
SELECT 31, 31, 80, 10 , 3.5 , 0, 2, NULL, NULL, 66 FROM dual UNION ALL
SELECT 32, 32, 1 , 15 , 18 , 0, 2, NULL, NULL, 67 FROM dual UNION ALL
SELECT 33, 32, 43, 20 , 46 , 0, 2, NULL, NULL, 68 FROM dual UNION ALL
SELECT 34, 33, 19, 30 , 9.2 , 0, 2, NULL, 97 , 81 FROM dual UNION ALL
SELECT 35, 34, 19, 20 , 9.2 , 0, 2, NULL, NULL, 69 FROM dual UNION ALL
SELECT 36, 35, 48, 10 , 12.75 , 0, 2, NULL, NULL, 70 FROM dual UNION ALL
SELECT 37, 36, 41, 200, 9.65 , 0, 2, NULL, 98 , 79 FROM dual UNION ALL
SELECT 38, 37, 8 , 17 , 40 , 0, 2, NULL, NULL, 71 FROM dual UNION ALL
SELECT 39, 38, 43, 300, 46 , 0, 2, NULL, 99 , 77 FROM dual UNION ALL
SELECT 40, 39, 48, 100, 12.75 , 0, 2, NULL, 100 , 75 FROM dual UNION ALL
SELECT 41, 40, 81, 200, 2.99 , 0, 2, NULL, 101 , 73 FROM dual UNION ALL
SELECT 42, 41, 43, 300, 46 , 0, 1, NULL, 102 , 104 FROM dual UNION ALL
SELECT 43, 42, 6 , 10 , 25 , 0, 2, NULL, NULL, 84 FROM dual UNION ALL
SELECT 44, 42, 4 , 10 , 22 , 0, 2, NULL, NULL, 85 FROM dual UNION ALL
SELECT 45, 42, 19, 10 , 9.2 , 0, 2, NULL, 103 , 110 FROM dual UNION ALL
SELECT 46, 43, 80, 20 , 3.5 , 0, 1, NULL, NULL, 86 FROM dual UNION ALL
SELECT 47, 43, 81, 50 , 2.99 , 0, 1, NULL, NULL, 87 FROM dual UNION ALL
SELECT 48, 44, 1 , 25 , 18 , 0, 1, NULL, NULL, 88 FROM dual UNION ALL
SELECT 49, 44, 43, 25 , 46 , 0, 1, NULL, NULL, 89 FROM dual UNION ALL
SELECT 50, 44, 81, 25 , 2.99 , 0, 1, NULL, NULL, 90 FROM dual UNION ALL
SELECT 51, 45, 41, 50 , 9.65 , 0, 2, NULL, 104 , 116 FROM dual UNION ALL
SELECT 52, 45, 40, 50 , 18.4 , 0, 2, NULL, NULL, 91 FROM dual UNION ALL
SELECT 53, 46, 57, 100, 19.5 , 0, 2, NULL, 105 , 101 FROM dual UNION ALL
SELECT 54, 46, 72, 50 , 34.8 , 0, 2, NULL, 106 , 114 FROM dual UNION ALL
SELECT 55, 47, 34, 300, 14 , 0, 2, NULL, 107 , 108 FROM dual UNION ALL
SELECT 56, 48, 8 , 25 , 40 , 0, 2, NULL, 108 , 106 FROM dual UNION ALL
SELECT 57, 48, 19, 25 , 9.2 , 0, 2, NULL, 109 , 112 FROM dual UNION ALL
SELECT 59, 50, 21, 20 , 10 , 0, 2, NULL, NULL, 92 FROM dual UNION ALL
SELECT 60, 51, 5 , 25 , 21.35 , 0, 2, NULL, NULL, 93 FROM dual UNION ALL
SELECT 61, 51, 41, 30 , 9.65 , 0, 2, NULL, NULL, 94 FROM dual UNION ALL
SELECT 62, 51, 40, 30 , 18.4 , 0, 2, NULL, NULL, 95 FROM dual UNION ALL
SELECT 66, 56, 48, 10 , 12.75 , 0, 2, NULL, 111 , 99 FROM dual UNION ALL
SELECT 67, 55, 34, 87 , 14 , 0, 2, NULL, NULL, 117 FROM dual UNION ALL
SELECT 68, 79, 7 , 30 , 30 , 0, 2, NULL, NULL, 119 FROM dual UNION ALL
SELECT 69, 79, 51, 30 , 53 , 0, 2, NULL, NULL, 118 FROM dual UNION ALL
SELECT 70, 78, 17, 40 , 39 , 0, 2, NULL, NULL, 120 FROM dual UNION ALL
SELECT 71, 77, 6 , 90 , 25 , 0, 2, NULL, NULL, 121 FROM dual UNION ALL
SELECT 72, 76, 4 , 30 , 22 , 0, 2, NULL, NULL, 122 FROM dual UNION ALL
SELECT 73, 75, 48, 40 , 12.75 , 0, 2, NULL, NULL, 123 FROM dual UNION ALL
SELECT 74, 74, 48, 40 , 12.75 , 0, 2, NULL, NULL, 124 FROM dual UNION ALL
SELECT 75, 73, 41, 10 , 9.65 , 0, 2, NULL, NULL, 125 FROM dual UNION ALL
SELECT 76, 72, 43, 5 , 46 , 0, 2, NULL, NULL, 126 FROM dual UNION ALL
SELECT 77, 71, 40, 40 , 18.4 , 0, 2, NULL, NULL, 127 FROM dual UNION ALL
SELECT 78, 70, 8 , 20 , 40 , 0, 2, NULL, NULL, 128 FROM dual UNION ALL
SELECT 79, 69, 80, 15 , 3.5 , 0, 2, NULL, NULL, 129 FROM dual UNION ALL
SELECT 80, 67, 74, 20 , 10 , 0, 2, NULL, NULL, 130 FROM dual UNION ALL
SELECT 81, 60, 72, 40 , 34.8 , 0, 2, NULL, NULL, 131 FROM dual UNION ALL
SELECT 82, 63, 3 , 50 , 10 , 0, 2, NULL, NULL, 132 FROM dual UNION ALL
SELECT 83, 63, 8 , 3 , 40 , 0, 2, NULL, NULL, 133 FROM dual UNION ALL
SELECT 84, 58, 20, 40 , 81 , 0, 2, NULL, NULL, 134 FROM dual UNION ALL
SELECT 85, 58, 52, 40 , 7 , 0, 2, NULL, NULL, 135 FROM dual UNION ALL
SELECT 86, 80, 56, 10 , 38 , 0, 1, NULL, NULL, 136 FROM dual UNION ALL
SELECT 90, 81, 81, 0 , 2.99 , 0, 5, NULL, NULL, NULL FROM dual UNION ALL
SELECT 91, 81, 56, 0 , 38 , 0, 0, NULL, NULL, NULL FROM dual;
/* End of order_details */
/* purchase_orders */
INSERT INTO northwind.purchase_orders (id, supplier_id, created_by, submitted_date, creation_date, status_id, expected_date, shipping_fee, taxes, payment_date, payment_amount, payment_method, notes, approved_by, approved_date, submitted_by)
SELECT 90, 1, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 91, 3, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 92, 2, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 93, 5, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 94, 6, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 95, 4, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 96, 1, 5, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #30', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 5 FROM dual UNION ALL
SELECT 97, 2, 7, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #33', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 7 FROM dual UNION ALL
SELECT 98, 2, 4, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #36', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 4 FROM dual UNION ALL
SELECT 99, 1, 3, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #38', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 3 FROM dual UNION ALL
SELECT 100, 2, 9, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #39', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 9 FROM dual UNION ALL
SELECT 101, 1, 2, to_timestamp('2006-01-14', 'YY-MM-DD'), to_timestamp('2006-01-22', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #40', 2, to_timestamp('2006-01-22', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 102, 1, 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #41', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 1 FROM dual UNION ALL
SELECT 103, 2, 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #42', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 1 FROM dual UNION ALL
SELECT 104, 2, 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #45', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 1 FROM dual UNION ALL
SELECT 105, 5, 7, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, 'Check' , 'Purchase generated based on Order #46', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 7 FROM dual UNION ALL
SELECT 106, 6, 7, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #46', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 7 FROM dual UNION ALL
SELECT 107, 1, 6, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #47', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 6 FROM dual UNION ALL
SELECT 108, 2, 4, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #48', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 4 FROM dual UNION ALL
SELECT 109, 2, 4, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #48', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 4 FROM dual UNION ALL
SELECT 110, 1, 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #49', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 3 FROM dual UNION ALL
SELECT 111, 1, 2, to_timestamp('2006-03-31', 'YY-MM-DD'), to_timestamp('2006-03-31', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, 'Purchase generated based on Order #56', 2, to_timestamp('2006-04-04', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 140, 6, 7, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-04-25', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 141, 8, 7, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, NULL, NULL, 2, to_timestamp('2006-04-25', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 142, 8, 3, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 2, NULL, 0, 0, NULL, 0, 'Check' , NULL, 2, to_timestamp('2006-04-25', 'YY-MM-DD'), 2 FROM dual UNION ALL
SELECT 146, 2, 2, to_timestamp('2006-04-26', 'YY-MM-DD'), to_timestamp('2006-04-26', 'YY-MM-DD'), 1, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 2 FROM dual UNION ALL
SELECT 147, 7, 2, to_timestamp('2006-04-26', 'YY-MM-DD'), to_timestamp('2006-04-26', 'YY-MM-DD'), 1, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 2 FROM dual UNION ALL
SELECT 148, 5, 2, to_timestamp('2006-04-26', 'YY-MM-DD'), to_timestamp('2006-04-26', 'YY-MM-DD'), 1, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 2 FROM dual;
/* end of purchase_orders; */
/* inventory_transactions */
INSERT INTO northwind.inventory_transactions (id, transaction_type, transaction_created_date, transaction_modified_date, product_id, quantity, purchase_order_id, customer_order_id, comments)
SELECT 35 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 80, 75 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 36 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 72, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 37 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 52, 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 38 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 56, 120, NULL, NULL, NULL FROM dual UNION ALL
SELECT 39 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 57, 80 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 40 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 6 , 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 41 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 7 , 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 42 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 8 , 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 43 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 14, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 44 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 17, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 45 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 19, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 46 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 20, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 47 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 21, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 48 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 40, 120, NULL, NULL, NULL FROM dual UNION ALL
SELECT 49 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 41, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 50 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 48, 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 51 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 51, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 52 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 74, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 53 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 77, 60 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 54 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 3 , 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 55 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 4 , 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 56 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 5 , 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 57 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 65, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 58 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 66, 80 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 59 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 1 , 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 60 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 34, 60 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 61 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 43, 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 62 , 1, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 81, 125, NULL, NULL, NULL FROM dual UNION ALL
SELECT 63 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 80, 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 64 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 7 , 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 65 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 51, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 66 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 80, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 67 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 1 , 15 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 68 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-22', 'YY-MM-DD'), 43, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 69 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 19, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 70 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 48, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 71 , 2, to_timestamp('2006-03-22', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 8 , 17 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 72 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 200, NULL, NULL, NULL FROM dual UNION ALL
SELECT 73 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 200, NULL, NULL, 'Fill Back Ordered product, Order #40' FROM dual UNION ALL
SELECT 74 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 48, 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 75 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 48, 100, NULL, NULL, 'Fill Back Ordered product, Order #39' FROM dual UNION ALL
SELECT 76 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 43, 300, NULL, NULL, NULL FROM dual UNION ALL
SELECT 77 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 43, 300, NULL, NULL, 'Fill Back Ordered product, Order #38' FROM dual UNION ALL
SELECT 78 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 41, 200, NULL, NULL, NULL FROM dual UNION ALL
SELECT 79 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 41, 200, NULL, NULL, 'Fill Back Ordered product, Order #36' FROM dual UNION ALL
SELECT 80 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 19, 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 81 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 19, 30 , NULL, NULL, 'Fill Back Ordered product, Order #33' FROM dual UNION ALL
SELECT 82 , 1, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 34, 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 83 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 34, 100, NULL, NULL, 'Fill Back Ordered product, Order #30' FROM dual UNION ALL
SELECT 84 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 6 , 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 85 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 4 , 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 86 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 80, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 87 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 50 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 88 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 1 , 25 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 89 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 43, 25 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 90 , 3, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-03-24', 'YY-MM-DD'), 81, 25 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 91 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 40, 50 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 92 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 21, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 93 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 5 , 25 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 94 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 95 , 2, to_timestamp('2006-03-24', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 40, 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 96 , 3, to_timestamp('2006-03-30', 'YY-MM-DD'), to_timestamp('2006-03-30', 'YY-MM-DD'), 34, 12 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 97 , 3, to_timestamp('2006-03-30', 'YY-MM-DD'), to_timestamp('2006-03-30', 'YY-MM-DD'), 34, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 98 , 3, to_timestamp('2006-03-30', 'YY-MM-DD'), to_timestamp('2006-03-30', 'YY-MM-DD'), 34, 1 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 99 , 2, to_timestamp('2006-04-03', 'YY-MM-DD'), to_timestamp('2006-04-03', 'YY-MM-DD'), 48, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 100, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 57, 100, NULL, NULL, NULL FROM dual UNION ALL
SELECT 101, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 57, 100, NULL, NULL, 'Fill Back Ordered product, Order #46' FROM dual UNION ALL
SELECT 102, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 50 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 103, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 43, 250, NULL, NULL, NULL FROM dual UNION ALL
SELECT 104, 3, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 43, 300, NULL, NULL, 'Fill Back Ordered product, Order #41' FROM dual UNION ALL
SELECT 105, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 25 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 106, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 25 , NULL, NULL, 'Fill Back Ordered product, Order #48' FROM dual UNION ALL
SELECT 107, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 300, NULL, NULL, NULL FROM dual UNION ALL
SELECT 108, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 300, NULL, NULL, 'Fill Back Ordered product, Order #47' FROM dual UNION ALL
SELECT 109, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 25 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 110, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 10 , NULL, NULL, 'Fill Back Ordered product, Order #42' FROM dual UNION ALL
SELECT 111, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 112, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 19, 25 , NULL, NULL, 'Fill Back Ordered product, Order #48' FROM dual UNION ALL
SELECT 113, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 72, 50 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 114, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 72, 50 , NULL, NULL, 'Fill Back Ordered product, Order #46' FROM dual UNION ALL
SELECT 115, 1, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 50 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 116, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 50 , NULL, NULL, 'Fill Back Ordered product, Order #45' FROM dual UNION ALL
SELECT 117, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 34, 87 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 118, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 51, 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 119, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 7 , 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 120, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 17, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 121, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 6 , 90 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 122, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 4 , 30 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 123, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 48, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 124, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 48, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 125, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 41, 10 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 126, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 43, 5 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 127, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 40, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 128, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 129, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 80, 15 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 130, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 74, 20 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 131, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 72, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 132, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 3 , 50 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 133, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 8 , 3 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 134, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 20, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 135, 2, to_timestamp('2006-04-04', 'YY-MM-DD'), to_timestamp('2006-04-04', 'YY-MM-DD'), 52, 40 , NULL, NULL, NULL FROM dual UNION ALL
SELECT 136, 3, to_timestamp('2006-04-25', 'YY-MM-DD'), to_timestamp('2006-04-25', 'YY-MM-DD'), 56, 110, NULL, NULL, NULL FROM dual;
/* End of inventory_transactions */
/* purchase_order_details */
INSERT INTO northwind.purchase_order_details (id, purchase_order_id, product_id, quantity, unit_cost, date_received, posted_to_inventory, inventory_id)
SELECT 238, 90 , 1 , 40 , 14, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 59 FROM dual UNION ALL
SELECT 239, 91 , 3 , 100, 8 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 54 FROM dual UNION ALL
SELECT 240, 91 , 4 , 40 , 16, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 55 FROM dual UNION ALL
SELECT 241, 91 , 5 , 40 , 16, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 56 FROM dual UNION ALL
SELECT 242, 92 , 6 , 100, 19, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 40 FROM dual UNION ALL
SELECT 243, 92 , 7 , 40 , 22, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 41 FROM dual UNION ALL
SELECT 244, 92 , 8 , 40 , 30, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 42 FROM dual UNION ALL
SELECT 245, 92 , 14, 40 , 17, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 43 FROM dual UNION ALL
SELECT 246, 92 , 17, 40 , 29, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 44 FROM dual UNION ALL
SELECT 247, 92 , 19, 20 , 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 45 FROM dual UNION ALL
SELECT 248, 92 , 20, 40 , 61, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 46 FROM dual UNION ALL
SELECT 249, 92 , 21, 20 , 8 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 47 FROM dual UNION ALL
SELECT 250, 90 , 34, 60 , 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 60 FROM dual UNION ALL
SELECT 251, 92 , 40, 120, 14, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 48 FROM dual UNION ALL
SELECT 252, 92 , 41, 40 , 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 49 FROM dual UNION ALL
SELECT 253, 90 , 43, 100, 34, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 61 FROM dual UNION ALL
SELECT 254, 92 , 48, 100, 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 50 FROM dual UNION ALL
SELECT 255, 92 , 51, 40 , 40, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 51 FROM dual UNION ALL
SELECT 256, 93 , 52, 100, 5, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 37 FROM dual UNION ALL
SELECT 257, 93 , 56, 120, 28, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 38 FROM dual UNION ALL
SELECT 258, 93 , 57, 80 , 15, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 39 FROM dual UNION ALL
SELECT 259, 91 , 65, 40 , 16, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 57 FROM dual UNION ALL
SELECT 260, 91 , 66, 80 , 13, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 58 FROM dual UNION ALL
SELECT 261, 94 , 72, 40 , 26, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 36 FROM dual UNION ALL
SELECT 262, 92 , 74, 20 , 8, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 52 FROM dual UNION ALL
SELECT 263, 92 , 77, 60 , 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 53 FROM dual UNION ALL
SELECT 264, 95 , 80, 75 , 3 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 35 FROM dual UNION ALL
SELECT 265, 90 , 81, 125, 2 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 62 FROM dual UNION ALL
SELECT 266, 96 , 34, 100, 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 82 FROM dual UNION ALL
SELECT 267, 97 , 19, 30 , 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 80 FROM dual UNION ALL
SELECT 268, 98 , 41, 200, 7 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 78 FROM dual UNION ALL
SELECT 269, 99 , 43, 300, 34, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 76 FROM dual UNION ALL
SELECT 270, 100, 48, 100, 10, to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 74 FROM dual UNION ALL
SELECT 271, 101, 81, 200, 2 , to_timestamp('2006-01-22', 'YY-MM-DD'), 1, 72 FROM dual UNION ALL
SELECT 272, 102, 43, 300, 34, NULL, 0, NULL FROM dual UNION ALL
SELECT 273, 103, 19, 10 , 7 , to_timestamp('2006-04-17', 'YY-MM-DD'), 1, 111 FROM dual UNION ALL
SELECT 274, 104, 41, 50 , 7 , to_timestamp('2006-04-06', 'YY-MM-DD'), 1, 115 FROM dual UNION ALL
SELECT 275, 105, 57, 100, 15, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 100 FROM dual UNION ALL
SELECT 276, 106, 72, 50 , 26, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 113 FROM dual UNION ALL
SELECT 277, 107, 34, 300, 10, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 107 FROM dual UNION ALL
SELECT 278, 108, 8 , 25 , 30, to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 105 FROM dual UNION ALL
SELECT 279, 109, 19, 25 , 7 , to_timestamp('2006-04-05', 'YY-MM-DD'), 1, 109 FROM dual UNION ALL
SELECT 280, 110, 43, 250, 34, to_timestamp('2006-04-10', 'YY-MM-DD'), 1, 103 FROM dual UNION ALL
SELECT 281, 90 , 1 , 40 , 14, NULL, 0, NULL FROM dual UNION ALL
SELECT 282, 92 , 19, 20 , 7 , NULL, 0, NULL FROM dual UNION ALL
SELECT 283, 111, 34, 50 , 10, to_timestamp('2006-04-04', 'YY-MM-DD'), 1, 102 FROM dual UNION ALL
SELECT 285, 91 , 3 , 50 , 8 , NULL, 0, NULL FROM dual UNION ALL
SELECT 286, 91 , 4 , 40 , 16, NULL, 0, NULL FROM dual UNION ALL
SELECT 288, 140, 85, 10 , 9 , NULL, 0, NULL FROM dual UNION ALL
SELECT 289, 141, 6 , 10 , 18.75, NULL, 0, NULL FROM dual UNION ALL
SELECT 290, 142, 1 , 1 , 13.5, NULL, 0, NULL FROM dual UNION ALL
SELECT 292, 146, 20, 40 , 60, NULL, 0, NULL FROM dual UNION ALL
SELECT 293, 146, 51, 40 , 39, NULL, 0, NULL FROM dual UNION ALL
SELECT 294, 147, 40, 120, 13, NULL, 0, NULL FROM dual UNION ALL
SELECT 295, 148, 72, 40 , 26, NULL, 0, NULL FROM dual;
/* purchase_order_details */
/* invoices */
INSERT INTO northwind.invoices (id, order_id, invoice_date, due_date, tax, shipping, amount_due)
SELECT 5 , 31, to_timestamp('2006-03-22', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 6 , 32, to_timestamp('2006-03-22', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 7 , 40, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 8 , 39, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 9 , 38, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 10, 37, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 11, 36, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 12, 35, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 13, 34, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 14, 33, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 15, 30, to_timestamp('2006-03-24', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 16, 56, to_timestamp('2006-04-03', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 17, 55, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 18, 51, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 19, 50, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 20, 48, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 21, 47, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 22, 46, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 23, 45, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 24, 79, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 25, 78, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 26, 77, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 27, 76, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 28, 75, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 29, 74, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 30, 73, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 31, 72, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 32, 71, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 33, 70, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 34, 69, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 35, 67, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 36, 42, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 37, 60, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 38, 63, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual UNION ALL
SELECT 39, 58, to_timestamp('2006-04-04', 'YY-MM-DD'), NULL, 0, 0, 0 FROM dual;
/* end of invoices */
/* strings */
INSERT INTO northwind.strings (string_id, string_data)
SELECT 2 , 'Northwind Traders' FROM dual UNION ALL
SELECT 3 , 'Cannot remove posted inventory!' FROM dual UNION ALL
SELECT 4 , 'Back ordered product filled for Order #|' FROM dual UNION ALL
SELECT 5 , 'Discounted price below cost!' FROM dual UNION ALL
SELECT 6 , 'Insufficient inventory.' FROM dual UNION ALL
SELECT 7 , 'Insufficient inventory. Do you want to create a purchase order?' FROM dual UNION ALL
SELECT 8 , 'Purchase orders were successfully created for | products' FROM dual UNION ALL
SELECT 9 , 'There are no products below their respective reorder levels' FROM dual UNION ALL
SELECT 10, 'Must specify customer name!' FROM dual UNION ALL
SELECT 11, 'Restocking will generate purchase orders for all products below desired inventory levels. Do you want to continue?' FROM dual UNION ALL
SELECT 12, 'Cannot create purchase order. No suppliers listed for specified product' FROM dual UNION ALL
SELECT 13, 'Discounted price is below cost!' FROM dual UNION ALL
SELECT 14, 'Do you want to continue?' FROM dual UNION ALL
SELECT 15, 'Order is already invoiced. Do you want to print the invoice?' FROM dual UNION ALL
SELECT 16, 'Order does not contain any line items' FROM dual UNION ALL
SELECT 17, 'Cannot create invoice! Inventory has not been allocated for each specified product.' FROM dual UNION ALL
SELECT 18, 'Sorry, there are no sales in the specified time period' FROM dual UNION ALL
SELECT 19, 'Product successfully restocked.' FROM dual UNION ALL
SELECT 21, 'Product does not need restocking! Product is already at desired inventory level.' FROM dual UNION ALL
SELECT 22, 'Product restocking failed!' FROM dual UNION ALL
SELECT 23, 'Invalid login specified!' FROM dual UNION ALL
SELECT 24, 'Must first select reported!' FROM dual UNION ALL
SELECT 25, 'Changing supplier will remove purchase line items, continue?' FROM dual UNION ALL
SELECT 26, 'Purchase orders were successfully submitted for | products. Do you want to view the restocking report?' FROM dual UNION ALL
SELECT 27, 'There was an error attempting to restock inventory levels.' FROM dual UNION ALL
SELECT 28, '| product(s) were successfully restocked. Do you want to view the restocking report?' FROM dual UNION ALL
SELECT 29, 'You cannot remove purchase line items already posted to inventory!' FROM dual UNION ALL
SELECT 30, 'There was an error removing one or more purchase line items.' FROM dual UNION ALL
SELECT 31, 'You cannot modify quantity for purchased product already received or posted to inventory.' FROM dual UNION ALL
SELECT 32, 'You cannot modify price for purchased product already received or posted to inventory.' FROM dual UNION ALL
SELECT 33, 'Product has been successfully posted to inventory.' FROM dual UNION ALL
SELECT 34, 'Sorry, product cannot be successfully posted to inventory.' FROM dual UNION ALL
SELECT 35, 'There are orders with this product on back order. Would you like to fill them now?' FROM dual UNION ALL
SELECT 36, 'Cannot post product to inventory without specifying received date!' FROM dual UNION ALL
SELECT 37, 'Do you want to post received product to inventory?' FROM dual UNION ALL
SELECT 38, 'Initialize purchase, orders, and inventory data?' FROM dual UNION ALL
SELECT 39, 'Must first specify employee name!' FROM dual UNION ALL
SELECT 40, 'Specified user must be logged in to approve purchase!' FROM dual UNION ALL
SELECT 41, 'Purchase order must contain completed line items before it can be approved' FROM dual UNION ALL
SELECT 42, 'Sorry, you do not have permission to approve purchases.' FROM dual UNION ALL
SELECT 43, 'Purchase successfully approved' FROM dual UNION ALL
SELECT 44, 'Purchase cannot be approved' FROM dual UNION ALL
SELECT 45, 'Purchase successfully submitted for approval' FROM dual UNION ALL
SELECT 46, 'Purchase cannot be submitted for approval' FROM dual UNION ALL
SELECT 47, 'Sorry, purchase order does not contain line items' FROM dual UNION ALL
SELECT 48, 'Do you want to cancel this order?' FROM dual UNION ALL
SELECT 49, 'Canceling an order will permanently delete the order. Are you sure you want to cancel?' FROM dual UNION ALL
SELECT 100, 'Your order was successfully canceled.' FROM dual UNION ALL
SELECT 101, 'Cannot cancel an order that has items received and posted to inventory.' FROM dual UNION ALL
SELECT 102, 'There was an error trying to cancel this order.' FROM dual UNION ALL
SELECT 103, 'The invoice for this order has not yet been created.' FROM dual UNION ALL
SELECT 104, 'Shipping information is not complete. Please specify all shipping information and try again.' FROM dual UNION ALL
SELECT 105, 'Cannot mark as shipped. Order must first be invoiced!' FROM dual UNION ALL
SELECT 106, 'Cannot cancel an order that has already shipped!' FROM dual UNION ALL
SELECT 107, 'Must first specify salesperson!' FROM dual UNION ALL
SELECT 108, 'Order is now marked closed.' FROM dual UNION ALL
SELECT 109, 'Order must first be marked shipped before closing.' FROM dual UNION ALL
SELECT 110, 'Must first specify payment information!' FROM dual UNION ALL
SELECT 111, 'There was an error attempting to restock inventory levels. | product(s) were successfully restocked.' FROM dual UNION ALL
SELECT 112, 'You must supply a Unit Cost.' FROM dual UNION ALL
SELECT 113, 'Fill back ordered product, Order #|' FROM dual UNION ALL
SELECT 114, 'Purchase generated based on Order #|' FROM dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment