SQL Query to find spaces in a data column

select *from (select 'testname@email.com ,noname@gmail.com  ' email from dual) where regexp_like(email,'(^ | $)')

How to search for a text from files in a directory on Linux

 find -type f -name "*.xml" -exec grep -l 'searchtext' {} +

Use the above command to find all files (in this case xnl) containing specific text 'searchtext' on Linux