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

Home -> Community -> Usenet -> c.d.o.tools -> HELP!! String variable manipulation.

HELP!! String variable manipulation.

From: Newbie \(Joe\) <jranseth_at_hotmail.com>
Date: 2000/07/07
Message-ID: <rNq95.145$Rz1.892@news1.mts.net>#1/1 






Is there a mid$() function - or equivalent to it - in pl/sql?  I need to
pull the first X characters from a string, truncating the rest.
ie:  strA = "very_long_string_variable"


strB = left(strA, 10)



would result in strB = "very_long_"



Simple idea....can I get some help with the syntax?



Thank you,


Joe
Received on Fri Jul 07 2000 - 00:00:00 CDT












Original text of this message













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