Re: Oracle For Fun

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 28 Jan 2004 11:41:10 -0000
Message-ID: <40179fd7$0$23466$cc9e4d1f@news.dial.pipex.com>

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1a8199f459a926e0989a4f_at_news.individual.net...
>
> So BULK COLLECT tells Oracle to retrieve all the rows together rather
> than reading each row individually?
>
> And the LIMIT is what - to specify the maximum number of rows that
> should be retrieved?
>
> I really must read-up on this stuff...

http://otn.oracle.com/oramag/oracle/03-sep/o53plsql.html

as well as the usual manuals etc

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Wed Jan 28 2004 - 05:41:10 CST