Skip to Content

how to insert a values using for loop in procedure?

hi,

i tried to insert a records using for loop in proceedure but it throuh the error.

this is my code:

Create procedure "KABIL_PRACTICE"."FORLOOP_1" 
as begin
begin
declare i integer;
create column table "KABIL_PRACTICE"."FOR_LOOP_1" ("ID" integer);
for i in 1..10 do
insert into "KABIL_PRACTICE"."FOR_LOOP_1" values(:i);
end for;
end;


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers