You create a CLOB in Oracle through the database's Structured Query Language, or SQL. Using SQL's "ALTER TABLE" statement, you add a CLOB data item to an existing table in your business' database.

This article explores the internals of materialized views and demonstrates how to precompute complex aggregates—having Oracle dynamically rewrite SQL to reference precomputed aggregate information.

The CREATE TABLE AS SELECT (CTAS) operation above calls the C function createTableStmt, which extracts column affinities. The unknown type “razzamataz” was silently assigned numeric, and the blob type ...