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

Home -> Community -> Usenet -> c.d.o.misc -> Split/cut a string

Split/cut a string

From: jpabich <jpabich_at_eisincorporated.com>
Date: 19 Sep 2006 12:20:18 -0700
Message-ID: <1158693618.041264.115590@k70g2000cwa.googlegroups.com>


I have a stored procedure where I want to get the last characters off a string. Say I have

i VARCHAR2;

i := 'ABC12345';

I want to be able to get the 12345 off. How do I do this? Received on Tue Sep 19 2006 - 14:20:18 CDT

Original text of this message

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