可以呀,我刚才在8i中测试了,可以像对待VARCHAR2一样使用 SQL> create table test(id number(5),text long);Table createdSQL> insert into test values(5,'sina.com.cn');1 row insertedSQL> commit;Commit completeSQL> select * from test; ID TEXT ------ -------------------------------------------------------------------------------- 5 sina.com.cnSQL> desc test; Name Type Nullable Default Comments ---- --------- -------- ------- -------- ID NUMBER(5) Y TEXT LONG Y SQL>
SQL> create table test(id number(5),text long);Table createdSQL> insert into test values(5,'sina.com.cn');1 row insertedSQL> commit;Commit completeSQL> select * from test; ID TEXT
------ --------------------------------------------------------------------------------
5 sina.com.cnSQL> desc test;
Name Type Nullable Default Comments
---- --------- -------- ------- --------
ID NUMBER(5) Y
TEXT LONG Y SQL>