Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fetch data using like query

User_19BPUFeb 24 2020 — edited Apr 10 2020

Hi,

I want to fetch the orders placed through the public domain email address, my order table "aux_order" table. Please let me know what the public domain email address that should be considered and how we need to frame the SQL to get the order details for these public email address in one query?

select * from aux_order where email like lower ('%@gmail.com%') -- like wise for other public email address

Thanks.

This post has been answered by BrunoVroman on Feb 25 2020
Jump to Answer
Comments
Post Details
Added on Feb 24 2020
4 comments
202 views