17,377
社区成员
发帖
与我相关
我的任务
分享
DBMS_OUTPUT.put_line('追加第'||(i-1)||'条...');
BEGIN
declare
i number;
begin
FOR i IN 1201020001 .. 1201020201 LOOP
DBMS_OUTPUT.put_line('追加第'||(i-1)||'条...');
INSERT INTO t_photo (bh, photo)
values (i, (select photo from t_photo where bh='1201020001'));
DBMS_OUTPUT.put_line('追加第'||(i-1)||'条成功!');
END LOOP;
end;
END;
CREATE TABLE "XXZWZX"."TEST_PHOTO"
( "BH" VARCHAR2(10) NOT NULL ENABLE,
"PHOTO" BLOB,
CONSTRAINT "PK_T_PHOTO_BH" PRIMARY KEY ("BH")
)
COMMENT ON COLUMN "XXZWZX"."TEST_PHOTO"."BH" IS '图像编号';
COMMENT ON COLUMN "XXZWZX"."TEST_PHOTO"."PHOTO" IS '图像';
COMMENT ON TABLE "XXZWZX"."TEST_PHOTO" IS '图像表';
--1201020001
--select * from t_photo for update
--delete from t_photo where bh>1201020001
--select '1201020'||substr('00'||11,length('00'||11)-2) from dual
--DBMS_OUTPUT.put_line('追加第'||(i+1)||'条成功');
--如果需要追加的记录比较多也可以100条做一次commit;
BEGIN
declare
i number;
begin
FOR i IN 2 .. 201 LOOP
DBMS_OUTPUT.put_line('追加第'||(i+1)||'条...');
INSERT INTO t_photo (bh, photo)
values ('1201020'||substr('00'||i,length('00'||i)-2), (select photo from t_photo where bh='1201020001'));
DBMS_OUTPUT.put_line('追加第'||(i+1)||'条成功!');
END LOOP;
end;
END;