Oracle Warehouse Builder on an Oracle 12c Database

Oracle Database 12c Release 1 is available since a few hours. One important question for many data warehouse and ETL developers is: What happens to Oracle Warehouse Builder (OWB)?

Continue reading


Surprising SQL

In Oracle SQL statements it is not allowed to use reserved words as identifiers. For example, it would confuse the SQL parser – and us as well – to name a table as TABLE or a column as SELECT. Of course, it is possible to use such names when the name is written in double quotes, but a statement like CREATE TABLE “TABLE” is definitely not a good practice.

Continue reading