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)?
Oracle Warehouse Builder on an Oracle 12c Database
Reply
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)?
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.