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.

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 ...