Building Generic Search Screen via Dynamic SQL
-
Posted by Quest Customer Learning Team
- Last updated 4/13/21
- Share
Presented at INSYNC 21
Session ID: 101920
Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.
Watch the full-length video
You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.
Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.
Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.
Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?
