Friday 12 November 2010

Extract number from string in oracle

Use this to extract number from string in oracle pl/sql:

SELECT REPLACE(REGEXP_REPLACE('123 abc' , '[a-z]', ''),' ')
FROM dual;

1 comment:

  1. It would be a great to share a bit more on this matter. I’m glad I come across your site really informative post. Thanks for sharing this material.

    www.n8fan.net

    ReplyDelete

Number of Visitors