Re: what means a line of <> in PL/SQL

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Mon, 14 Jan 2002 17:16:08 GMT
Message-ID: <3c4311dd.553519500@news.alt.net>

On Mon, 14 Jan 2002 15:15:20 +0100, "Peter K" <P.Kloo_at_mylius.com> wrote:

>Hi,
>
>in a sqlserver -> oracle 8 migrated stored procedure i can read
>...
>end if;
><>
>while ....
>...
>
>what's the meaning of <> (guess it is not the relational operator)
>
>Cheers,
>Peter

Is that exactly what it says?

In Oracle, loops can be labeled.

<<This_Is_A_Loop_Label>>
LOOP
NULL;
END LOOP This_Is_A_Loop_Label;

It is usually unneeded, thought is may make the code look nice. However, if you need to exit an out loop, it is essential.

Brian Received on Mon Jan 14 2002 - 11:16:08 CST