PL/SQL (MOSC)

MOSC Banner

plsql code error

edited Nov 11, 2014 11:03PM in PL/SQL (MOSC) 2 commentsAnswered ✓

Hello,

I need to give i and j the same values I mean both columns the same values at a time how do I do this with plsql?Below is giving error

SQL> declare i number;

  2   j number;

  3  begin

  4  for i,j in 1 .. 10000

  5  loop

  6  insert into emp values(i,j);

  7  end loop;

  8  end;

  9  /

Best regards,

Vishal

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center