Remove first characters of string in Oracle Server

Question

I have Table1.column1 in a Oracle Server with text such as 12345678910.

How can I remove the first six characters of the string? The result should be 78910.

Possible duplicate of Oracle: remove first 4 characters from a string — brenners1302
– brenners1302, Commented Jan 20, 2016 at 0:49

MT0 · Accepted Answer · 2016-01-20 00:58:34Z

16

SELECT SUBSTR( column1, 7, LENGTH( column1 ) - 6 )
FROM   Table1;

or more simply:

SELECT SUBSTR( column1, 7 )
FROM   Table1;

answered Jan 20, 2016 at 0:58

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bob Jarvis - Слава Україні · Accepted Answer · 2016-01-20 02:46:06Z

6

If you know you want the last five characters of a string you can use a negative value for the second argument to SUBSTR, as in:

select substr('12345678910', -5) from dual;

which produces '78910'.

Best of luck.

answered Jan 20, 2016 at 2:46

50.2k10 gold badges81 silver badges119 bronze badges

Rahul · Accepted Answer · 2016-01-20 00:51:07Z

1

Have you tried using SUBSTR() function like

select substr(column1, 6, 5)
from Table1;

answered Jan 20, 2016 at 0:51

Rahul

78.1k14 gold badges80 silver badges132 bronze badges