OraFAQ Forum: SQL & PL/SQL » REGEXP

Home » SQL & PL/SQL » SQL & PL/SQL » REGEXP_SUBSTR (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

REGEXP_SUBSTR [message #357822]

Thu, 06 November 2008 15:45

theladyd
Messages: 13
Registered: September 2008

Junior Member

I have a column of numbers from 1 to 10 digits in length.
1
22
333
4444
55555
666666, etc.

I want to extract the last 2 digits of each number. I know how to extract from left to right REGEXP_SUBSTR(EMPLOYEE_NBR,'..', 5), how do I extract from right to left?

Thanks

Report message to a moderator

Re: REGEXP_SUBSTR [message #357823 is a reply to message #357822]

Thu, 06 November 2008 15:49

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why regular expressions? How about simple SUBSTR?

SQL> WITH test AS
  2   (SELECT 1 col FROM dual
  3    UNION SELECT 21 FROM dual
  4    UNION SELECT 312 FROM dual
  5    UNION SELECT 4234 FROM dual
  6    UNION SELECT 56543 FROM dual
  7   )
  8  SELECT col, SUBSTR(col, -2) FROM test;

       COL SU
---------- --
         1
        21 21
       312 12
      4234 34
     56543 43

SQL>

Report message to a moderator