请教各位，oracle中如何插入一个长字符串？

Question

你的插入语句是对的，你用的版本是多少？9i是可以的。

Answer 1

我试过，Oracle9i下SQL PlUS可以---------------------------------------------------------16:42:05 SQL> CREATE TABLE  TABLE1  (    
16:42:15   2      MATERIAL          VARCHAR(700),
16:42:15   3      SHIZAI_HOZAI          VARCHAR(200)  
16:42:15   4      );Table created.Elapsed: 00:00:00.01
16:42:15 SQL> insert into TABLE1 values('abcd5612345612345612345612345612345612345612345612345612345
6123456123456123456123456123456123456123456123456123456123456123456123456123456123456123456123456123
4561234561234561234561234561234561234561234561234561234561234561234561234561234561234561234561234561
2345612345612345612345612345612345612345612345612345612345612345612345612345612345612345612345612345
6123456123456123456123456123456123456123456123456123456123456123456123456123456123456123456123456123
4561234561234561234561234561234561234561234561234561234561234561234561234561234561234561234561234561
2345612345612345612345612345612345612345612345612345612345612345612345612345612345612345612345612345
612345612345612345612345612345612xyz','1234567890123456789012345678901234567890123456789012345678901
2345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901
23456789012345678901234567890');1 row created.Elapsed: 00:00:00.00
16:42:23 SQL>