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

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Query to list the Oracle RICEW Objects

Pass the application short name &APP_SHORT_NAME parameter to find RICE objects for the particular application and include any exclusion ...