Re: pl sql question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 14 Oct 1999 15:23:43 -0400
Message-ID: <mi0GONN2aj=4Y5Tz7jd0c3pl=VYP@4ax.com>

A copy of this was sent to "Rajkumar Manickavasagam (Raj)" <rmnckvsg_at_memphis.edu>
(if that email address didn't require changing) On Thu, 14 Oct 1999 13:00:53 -0500, you wrote:

>
>
>
>
>What would the equivalent of the expression, variable1 =
>substring(variable2, startposition, length) in Java, be in PL SQL?
>
>thanks
>raj

that would be:

variable1 := substr( variable2, frompos, forlength );

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 14 1999 - 14:23:43 CDT