Tuesday, December 6, 2022

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,'(^ | $)')

Unix commands to get the count of files

 ls -l *.rdf | wc -l