RE: String Manipulation

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 17 May 2007 14:07:31 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270C43ACAC@AABO-EXCHANGE02.bos.il.pqe>

Try this:
select
substr('instance.company.com',1,instr('instance.company.com','.')-1) from dual;

-Mark

--

Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA

"There are 10 types of people in the world: Those who understand binary, and those who don't."

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shivaswamy Raghunath Sent: Thursday, May 17, 2007 1:22 PM
To: Oracle-L
Subject: String Manipulation

Hello.

I need to get "instance" from ('instance.company.com') on SQLPLUS. How I can do this?

I tried to use REGEXP_SUBSTR function, but could not make much headway. Please note that, the LENGTH(instance) may vary.

So I guess, give me before first occurence of period(.) in the string is what I should ask to get.

TIA,
Shiva

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 17 2007 - 13:07:31 CDT