Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP!! String variable manipulation.
Joe,
You can do it with the SUBSTR function:
strB := substr (strA, 1, 10)
Thanks,
Paul
"Newbie (Joe)" <jranseth_at_hotmail.com> wrote in message
news:rNq95.145$Rz1.892_at_news1.mts.net...
> 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