RE: Reg. SQL Operator..

From: Javier Morales <Javier_at_infojobs.net>
Date: Tue, 21 Nov 2000 19:14:21 +0100
Message-Id: <10687.122642@fatcity.com>

even more faster !!!!

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
=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..

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).
>

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
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 Received on Tue Nov 21 2000 - 12:14:21 CST