SQL> CREATE TABLE t 2 ( 3 ISCT_ID NUMBER(10), 4 CONTENT CLOB 5 );
Table created.
SQL> insert into t values(1, 'test');
1 row created.
SQL> insert into t values(2, NULL);
1 row created.
SQL> update t set content='test2' where isct_id=2;
1 row updated.
SQL> select * from t;
ISCT_ID CONTENT ------------------------------------------------------- 1 test
2 test2
SQL>
_________________________________________________________________
Surf and talk on the phone at the same time with broadband Internet access. Get high-speed for as low as $29.95/month (depending on the local service providers in your area). https://broadband.msn.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nancy Hu INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).