Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Null operation

Re: Null operation

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Wed, 08 Sep 1999 17:28:13 GMT
Message-ID: <1104_936811693@prague_main>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US