Re: Simple Select Return Record

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.

- Vlad

On 6/9/05, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> 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

Other related posts: