Re: Simple Select Return Record

From: Vlad Sadilovskiy <vlovsky_at_gmail.com>
Date: Thu, 9 Jun 2005 09:32:54 -0400
Message-ID: <df9f25d505060906325b9de4e5@mail.gmail.com>

I think it'll fetch at least batch_size(arraysize) rows.

Could you please kindly provide your form of the query needed. Please, don't say it's bad without an alternative.

On 6/9/05, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
>=20
>=20

> Hi

>=20

> =20

>=20

> >select count(*)=3D20

>=20

> >from dual

>=20

> >where exists (select null from employee_tbl where employeeid=3D3D5);

>=20

> =20

>=20

> If excellent performance is a must, don't do that.=20

>=20

> To fetch a single row from a query and set a flag is faster.

>=20

> =20

>=20

> =20

>=20

> HTH

>=20

> Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 09 2005 - 09:38:17 CDT