Shows how to build the Order query featured in the Avitek Sample. For a given customer ID, view customer orders in both Broadband and Wireless data sources. Introduces the concept of a join. Includes examples of using both a hard-coded constant and a query parameter for the customer ID. A complete description of how to build this query is in the Getting Started guide.

Given first and last name for a customer, find their orders in both Broadband and Wireless data sources. Demonstrates use of two different join conditions. Includes examples of using optimization hints. A complete description of how to build the Simple Joins example query is in the Query Cookbook.

For a given customer ID, find the number of orders placed across two data sources. Uses a data view as one of the data sources. Demonstrates use of the "count" function. A complete description of how to build the Aggregates example query is in the Query Cookbook.

Find out if a given customer has open orders scheduled to ship before a specified date. Demonstrates use of "date-from-string-with-format" function. Includes an example of setting scope for a condition. A complete description of how to build the Date and Time Duration example query is in the Query Cookbook.

For a given customer ID, find details on customer orders across two data sources. Use a union to retrieve results from subordinate queries on each data source and concatenate the results. A complete description of how to build the Union example query is in the Query Cookbook.

Create a minus relationship (A-B) that returns all instances that are in data source "A" but not in data source "B". Includes an example of setting scope. A complete description of how to build the Minus example query is in the Query Cookbook.

Shows how to use Liquid Data to generate a Web service from a stored query. Also demonstrates how to test the query in BEA WebLogic Workshop. For a complete description of how to use Liquid Data to generate a Web service, see the topic Generating and Publishing Web Services in the Administration Guide.

Shows how to use Liquid Data to access a database stored procedure and use the stored procedure in a query. For a complete description of how to use stored procedures with Liquid Data, see the topic Defining Stored Proecdures in Building Queries and Data Views.

Shows how to use Liquid Data to access a user-defined complex parameter type in a query. The complex parameter type represents a real-time data stream, such as an order currently being placed. For a complete description of how to use complex parameter types with Liquid Data, see the topic Using Complex Parameter Types in Building Queries and Data Views.