Re: Reg. SQL Operator..

hi all,

I am very much happy with so many alternatives for [] operator (which is in Sybase).
Thank U very much friends.

Arul.

Jared Still wrote:

> On Tue, 21 Nov 2000, Javier Morales wrote:
>
> > even more faster !!!!
> >
> > select ename from emp where upper(ename) between 'A' and 'SZZZZ'
> > ---------------------------------------
> > Javier Morales - javier_at_infojobs.net
> > Administración 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
>
> >
> >
> >
> >
> >
> > -----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..
> >
> >
> > can also use
> >
> > select ename from emp where upper(substr(ename,1,1)) between 'A' and 'S'
> >
> > -ajay
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, November 21, 2000 1:01 AM
> >
> >
> > >
> > > 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.).
> > >
> > >
> > > 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).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ajay K
> > INET: ajay_at_tems.com
> >
> > 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
> >
> > 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).
> >
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> 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
Received on Wed Nov 22 2000 - 06:38:54 CST