RE: Reg. SQL Operator..

From: Kieran Murray <Kieran.Murray_at_esat.com>
Date: Tue, 21 Nov 2000 10:16:46 -0000
Message-Id: <10687.122592@fatcity.com>

Hi Ura,
Try 'Select empname from emp where empname < 'T'

Kieran

-----Original Message-----
From: Ura! [mailto:ura_at_ymz.yaroslavl.ru] Sent: 21 November 2000 06:15
To: Multiple recipients of list ORACLE-L Subject: Re: Reg. SQL Operator..

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

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

http://www.marketplace.ie
Ireland's Home for eBusiness Received on Tue Nov 21 2000 - 04:16:46 CST