Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> String Manipulation

String Manipulation

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Thu, 17 May 2007 13:22:28 -0400
Message-ID: <1e52ad820705171022paa910c2tc60b7384bb5f0a91@mail.gmail.com> 





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 - 12:22:28 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US