GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQSearch on a table with optional parameters
Hi,
We have search procedures with parameters that are optional.
In our select statements, we ignore all the parameters that are nulls.
Here is an example of a table and a procedure to achieve this:
create table TEMP_TEMPLATE
(
OBJECT_I...
Sponsored Links
Read Next: SQL , to get consecutive same att_id
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
