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!

How to avoid using UNION?

Robin BijuMay 7 2022

Hi, I have a table Employees with
employee_name
Age
In apex page I have a page item(p123_page_selector), which is a radio button. Its values are ALL and AGED.
So, when user selects 'ALL', I want to return all data from table employees.
When user selects 'AGED', I want to return all data from employees where age greater than 35.
I wrote query like below.
image.pngHow to write this query without using 'UNION'?

This post has been answered by Frank Kulash on May 7 2022
Jump to Answer

Comments

Post Details

Added on May 7 2022
4 comments
490 views