I need the oracle query to retrieve users who has @gmail extension mails from email column from users table.
select * from users where email like '%@gmail%'