RE: String Manipulation
- From: <jim.silverman@xxxxxxxxxxx>
- To: <shivaswamykr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 May 2007 13:45:04 -0400
The expression
substr ('instance.company.com', 1, instr ('instance.company.com',
'.') - 1)
should do what you want.
====================================
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641
FAX: 734-930-7611
E-Mail: jim.silverman@xxxxxxxxxxx
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
