Inserting a record in PL/SQL block using for loop is yielding error

Question

I am creating a table of inetegers called 'integer_properties' from 1 to 1000 the table columns are:

integer,isPrime,isOdd,isEven,digitCount;

I want to insert records using a for loop i tried following but the error says: 'missing SELECT keyword'

BEGIN
   for k in 1..1000
   loop
      insert into integer_properties(integer,
                                     isPrime,
                                     isEven,
                                     isOdd,
                                     digitCount)
         values(k,null,null,null,null);
   end loop;
END;

It is tedious to enter 1000 numbers with DDL command without using PL/SQL block. I am trying to enter the loop variable values in the integer column. Is it possible to do that?

Noel · Accepted Answer · 2013-07-17 14:35:18Z

5

You can do it in a single query.

insert into integer_properties
select level, null, null, null, null
from dual
connect by level <= 1000;

commit;

LEVEL is a pseudocolumn used in hierarchical queries.

Your code seems fine, but using INTEGER as column name ~~might be~~ is causing problem. If you enclose it in double quotes, it will work fine. So, better to avoid using keywords while naming columns.

edited Jul 17, 2013 at 14:35

answered Jul 17, 2013 at 6:08

Noel

10.6k30 gold badges53 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting a record in PL/SQL block using for loop is yielding error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related