Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


Views


There are a number of views in the MIMER_STORE schema to show various aspects of the functionality that can be supported.

View name
Description
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
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX