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.