SQL & PL/SQL

I use the following query to search a string value in the database:

SELECT * FROM ALL_source WHERE UPPER(text) LIKE '%ABC123XYZ%'; 

How do I search for a numeric value like 123456789 ?

I've tried this but didn't work:

SELECT * FROM ALL_source WHERE text = 123456789 ;