6 Replies Latest reply: Jun 25, 2014 5:00 AM by OraFighter RSS

    How to take last 7 digits from a varchar column

    OraFighter

      How to take last 7 digits from a varchar2 colum

       

      COL1

      12345678

      12345

      1234567890123

      1234567

       

      Out put should be as below

      COL1

      2345678

          12345

      7890123

      1234567

       

      any built in function or any other way please