Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Null operation
On Wed, 08 Sep 1999 16:46:34 GMT, Jenda_at_Krynicky.cz (Jenda Krynicky) wrote:
> A stupid question to most of you ... how do I say NOOP (Null operation) in PL/SQL?
>
> I have something like this in a procedure
>
> FOR rec IN c1 LOOP
> begin
> select ... into ... from table where ...;
>
> insert into othertable (...) values (...);
> end;
> END LOOP;
OK, I should have done it by
insert into othertable (...) SELECT ... from table where ...;
I do now. So everything works.
But I still think there must be some NOOP ;-)
Thanks anyway, Jenda
http://Jenda.Krynicky.cz
Received on Wed Sep 08 1999 - 12:28:13 CDT