April 2012

The value of Transact-SQL 2008 Table Value Constructor.

By Nicholas Geiger – KMCDATA I find the table value constructor to be quite useful at times. It allows one to form a multi-row table in a concise manner. It can be used in INSERT and MERGE statements, and as derived tables in the FROM clause. I’ve used it many times in data fix scripts […]

Read more →

ORA-38818

Get an ORA-38818 (illegal reference to editioned object) when trying to create a function-based index on a database with edition based redefinition turned on? The catch is that your function is in an editioned schema, but indexes are not editionable and cannot reference an editioned object. The work-around is quick and easy: 1) Create a […]

Read more →