How to Select only NUMBER values in SELECT statement

Use REGEXP_LIKE(column_name, '^[[:digit:]]+$') in where clause

SELECT <<column_name>> 
FROM   <<some_table>>
WHERE  REGEXP_LIKE(<<column_name>>, '^[[:digit:]]+$');

Output:

Useful Links:

Oracle: SQL query that returns rows with only numeric values