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

Home -> Community -> Usenet -> c.d.o.server -> Re: Anyone care to add the SQL and PL/SQL chapters?

Re: Anyone care to add the SQL and PL/SQL chapters?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Mon, 13 Aug 2001 09:54:36 GMT
Message-ID: <3b77a1a0.3668415@news>

On Sun, 12 Aug 2001 20:46:29 +0200, Lothar Armbruester <lothar.armbruester_at_t-online.de> wrote:

>
>What about these ones:
>
>SQL: insert into foot select bullet from gun;
> After it generates too much pain, you rollback.
>
>
>Oracle SQL: insert into foot select /*+ ORDERED */ bullet from gun:
> This hint causes the bullets to hit in the right order ;-)
>
>
>PL/SQL:
> begin
> for bul_rec in (select bullet from gun) loop
> utl_bullet.hit(bul_rec.bullet,foot);
> end loop;
> end;
> /
>
> Obvoiusly, utl_bullet requires a special Oracle release
> (maybe 8b, "b" for "bullet" ;-)
>

Thanks! I'll see what I can do with them. :-D

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Mon Aug 13 2001 - 04:54:36 CDT

Original text of this message

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