On Tue, 21 Nov 2000, Javier Morales wrote:
> even more faster !!!!
>=20
> select ename from emp where upper(ename) between 'A' and 'SZZZZ'
> ---------------------------------------
> Javier Morales - javier_at_infojobs.net
> Administraci=F3n Bases de Datos Oracle - InfoJobs.net
> Tel. +34 902 10 60 90 Ext. 2067
> Fax. +34 (93) 580 56 60
Even faster! ;)
Skip the upper() and do a fast full index scan.
Jared
> =20
>=20
>=20
>=20
>=20
> -----Mensaje original-----
> De: Ajay K [mailto:ajay_at_tems.com]
> Enviado el: martes 21 de noviembre de 2000 18:45
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Reg. SQL Operator..
>=20
>=20
> can also use
>=20
> select ename from emp where upper(substr(ename,1,1)) between 'A' and 'S'
>=20
> -ajay
>=20
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, November 21, 2000 1:01 AM
>=20
>=20
> >
> > Arul,
> > ----------------------------------------
> >
> > Ak> hi,
> >
> > Ak> I would like to know how to write a query to fetch a range of
> records?.
> >
> >
> > Ak> Say,for example. i have a table Emp with Empname ( a Varchar2 col.)=
=2E
> >
> >
> > Ak> To fetch Employees whose names starts with A to S .
> >
> >
> > Ak> Output should be :
> >
> >
> > Ak> Arul
> > Ak> Binesh
> > Ak> ..
> > Ak> ..
> > Ak> Rajan
> > Ak> Sathish
> >
> >
> > Ak> Is there any operator like [A-S] ? as in Sybase...
> > 1) select empname from emp where empname like 'A%' and empname like
> > 'B%' ....
> > 2) select ename from emp where substr(ename,1,1) in ('A','B',....)
> >
> > Ak> Thanks.
> >
> >
> > Ak> Arul.
> >
> >
> >
> >
> > ----------------------------------------
> > ura_at_ymz.yaroslavl.ru
> > Ura!
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ura!
> > INET: ura_at_ymz.yaroslavl.ru
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Ajay K
> INET: ajay_at_tems.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Javier Morales
> INET: Javier_at_infojobs.net
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20
Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Received on Tue Nov 21 2000 - 17:06:40 CST
