Custom search filters and results

Hello,

Take a look to the following table structure

my_table

  • name varchar2
  • position varchar2
  • year int

Is possible to create a custom search filter like the following?

name:
[ ] all
[ ] value________

position: [ select ][ v ]

  • position a
  • position b
  • position c

year: [ select ][ v ]

  • year a
  • year b
  • year c

[ search button ]

---- Results here-----

When the search button is triggered then results will be appear below. I do not want to use blank application because the idea is to take SC to the limit. A pseudo-code could be enough. Thank you in advance.

You can do a report with it table. SC has advanced search, you can do it throught this filter.