帮我写个PL/SQL块,也就是说把下面这句话循环执行1500次。数据是
1F001
1F002
这样加的
INSERT INTO room(num) VALUES ('1F001');
效果如下
1F001
1F002
1F003
1F004
1F005
……
……
1F1500
1F001
1F002
这样加的
INSERT INTO room(num) VALUES ('1F001');
效果如下
1F001
1F002
1F003
1F004
1F005
……
……
1F1500
DECLARE
in_x bigint;
in_char text;
BEGIN
in_x= 1F001;
for i in 1..1500 loop
in_char = to_char(in_x,'999999');
INSERT INTO room(num) VALUES (in_char);
in_char = in_char+1;
end loop;
END;
$$ LANGUAGE plpgsql;
大概思路是这样,没有具体调试