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: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 19 Sep 2006 22:02:17 +0200
Message-ID: <45104cc9$0$27254$636a55ce@news.free.fr> 






"jpabich" <jpabich_at_eisincorporated.com> a écrit dans le message de 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(i,1,3)




Regards


Michel Cadot
Received on Tue Sep 19 2006 - 15:02:17 CDT












Original text of this message













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