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.

I'm working on a similar project (Access, Oracle, and Sybase, with SQL Server to come), and here's what we've found, as far as I know:<BR><BR>Mostly ANSI SQL will convert without changes.

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

The SAS System uses information that is provided by the DBLOAD procedure to construct an SQL CREATE TABLE statement and passes it to the DBMS. The SAS System constructs an SQL INSERT statement for the ...