Download V9.2.1 - Mimer SQL

Transcript
2
New Features and Functions
Mimer SQL Structured Query Language
Examples:
localhost/testdb
my_node.mimer.se/supplier
my_node.mimer.se:1365/supplier_temp
Mimer SQL Structured Query Language
SUBSTRING on CLOB and NCLOB Columns (V9.2.5)
The SUBSTRING function can now be used on columns with data type CHARACTER
LARGE OBJECT or NATIONAL CHARACTER LARGE OBJECT.
Example:
SELECT column1,
SUBSTRING(clobcolumn FROM 1 FOR 50) AS intro
FROM sometable;
Using LIKE Predicate for CLOB and NCLOB Columns
(V9.2.4)
The LIKE predicate can now be used to search the contents of columns with data type
CHARACTER LARGE OBJECT or NATIONAL CHARACTER LARGE OBJECT.
Example:
SELECT * FROM tab1 WHERE clobcol LIKE '%Mimer%Uppsala%';
ORDER BY on Expressions (V9.2.4)
The ORDER BY clause can now contain expressions. An expression in the ORDER BY
specification must contain at least one column reference to a table in the query.
Examples:
SELECT column1 FROM sometable ORDER BY column2;
SELECT column1 FROM sometable ORDER BY ABS(column1);
SELECT column1 FROM sometable
ORDER BY CASE WHEN column1 < column2 THEN column1 ELSE column2 END;
table1 JOIN table2 USING (column1) ORDER BY somefunction(column1);
See Mimer SQL Reference Manual, Chapter 12 for more information.