昨天剛好要寫一個存儲過程，因為平常沒有經(jīng)常接觸，掉了一下坑，mark down下來提醒自己，上代碼：

CREATE or replace PROCEDURE XXX

AS

i number;

BEGIN

for i in 0..10 loop

INSERT INTO XXX

(id,

name,

client_id,

client_secret,

federated_protocol,

redirect_uri,

description,

authz_scopes,

status,

zone_id,

creation_time,

last_update_time,

extension)

VALUES

(CONCAT('id', TO_CHAR(i)),

CONCAT('name', TO_CHAR(i)),

'OfficeClientID987576576-57657-0988',

'6LBhwfZMMpwyQbdLEexbXeb',

'OIDC',

'www.xxx.com',

'ooo370',

'email',

'1',

'01',

'1495175948670',

'1495175948672',

'ex');

end loop;

commit;

END;

BEGIN

XXX;

END;

執(zhí)行完BEGIN ?END之后就可以循環(huán)插入進數(shù)據(jù)庫，效果如下圖：