There are a number of views in the MIMER_STORE schema to show various aspects of the functionality that can be supported.
CUSTOMER_DETAILS Based on the single table CUSTOMERS.Shows the simplest type of view - updateable if the user has the privilege. Allows a new customer to be added to the database. SWEDISH_CUSTOMERS Based on the previous view (i.e. views can be defined on views) but with a selection condition so that only Swedish customers are displayed.Uses a 'with check option' so that only Swedish customers can be operated on through this view. CUSTOMER_ADDRESSES Again based on the CUSTOMER_DETAILS view but also joined to the COUNTRIES table.Shows how PSM functions can be used from standard SQL statements, including applying pre-defined functions on the result.Demonstrates how to name the columns in a view definition. Introduces the coalesce expression.The join is slightly more complicated than it needs to be because the column names are not consistent. PRODUCT_DETAILS Forms a view across a number of tables, including an outer join on the PRODUCERS table.Note that the coalesce expression in the select list is named; all calculated columns in a view have to be named.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40