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 -> Re: Split/cut a string

Re: Split/cut a string

From: Acme Acmeson <nahdsl232734_at_nahvip.cybercity.dk>
Date: Tue, 19 Sep 2006 22:11:53 +0200
Message-ID: <45104f08$0$143$157c6196@dreader1.cybercity.dk> 






"jpabich" <jpabich_at_eisincorporated.com> wrote in message 
news:1158693618.041264.115590_at_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?

>




substr, instr 
Received on Tue Sep 19 2006 - 15:11:53 CDT












Original text of this message













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