oracle 扩展字段脚本,如何使用一个字段将oracle插入脚本作为CLOB？

请记住,SQL字符串不能大于4000字节,而Pl / SQL可以具有大到32767字节的字符串.见下面的例子,通过一个匿名块插入一个大字符串,我相信会做你需要做的一切.

注意我将varchar2(32000)更改为CLOB

set serveroutput ON

CREATE TABLE testclob

(

id NUMBER,

c CLOB,

d VARCHAR2(4000)

);

DECLARE

reallybigtextstring CLOB := '123';

i INT;

BEGIN

WHILE Length(reallybigtextstring) <= 60000 LOOP

reallybigtextstring := reallybigtextstring

|| '000000000000000000000000000000000';

END LOOP;

INSERT INTO testclob

(id,

c,

d)

VALUES (0,

reallybigtextstring,

'done');

dbms_output.Put_line('I have finished inputting your clob: '

|| Length(reallybigtextstring));

END;

/

SELECT *

FROM testclob;

"I have finished inputting your clob: 60030"