XML B2B Application: Setting Up the Database Schema

The following schema scripts are provided here in the order in which they should be executed:

• Create and Build the Retailer and Supplier Schemas
  • SQL Example 1: Set up the Retailer and Supplier Environment -- BuildAll.sql

  • This calls, SQL Example 2: Create and Populate the Retailer-Supplier Schema -- BuildSchema.sql

• Create the AQ Environment and Queue Tables
  • SQL Example 3: Set Up the Environment for AQ -- mkAQUser.sql

  • SQL Example 4: Call the AQ Queue Creation Scripts -- mkQ.sql. This calls:
    • SQL (PL/SQL) Example 5: Create Table, AppOne_QTab -- mkQueueTableApp1.sql

    • SQL (PL/SQL) Example 6: Create Table, AppTwo_QTab -- mkQueueTableApp2.sql

    • SQL (PL/SQL) Example 7: Create Table, AppThree_QTab -- mkQueueTableApp3.sql

    • SQL (PL/SQL) Example 8: Create Table, AppFour_QTab -- mkQueueTableApp4.sql

• Create the Broker Schema Including XSL Stylesheet Table
  • SQL Example 9: Create Broker Schema -- mkSSTables.sql.

    This calls:

  • SQL (PL/SQL) Example 10: Input XSL data into CLOB. Populate the Broker Schema -- setup.sql

• Cleaning Up Your Environment and Preparing to Rerun Application
  • SQL Example 11: Stops and Drops Queue Applications. Starts Queue Applications -- reset.sql