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.