How can you retrieve the numeric values from varchar2 type column?

Hi, You can use regexp. for e.g.,

Code
SELECT to_number(regexp_replace(hello123,[[:alpha:]],)) FROM dual;

Output:
--------------
123

Code
SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

Code
SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

Code
SELECT column1 FROM TABLE WHERE column1 NOT LIKE %[^0-9]% 

Query is missing quotes. The corrected query is..

Code
SELECT * FROM table_name WHERE regexp_like(column_name,^[0-9]+$);

Code
SELECT * FROM table_name WHERE regexp_like (column_name, ^[0 - 9] + $);

Using regexp_replace function

Code
SELECT to_number(regexp_replace(abc123efg456kjhdf,[[:alpha:]])) 
FROM dual;