Tech Tutorials Database
GeekArticles FAQ Oracle FAQ
 

Search on a table with optional parameters

 
Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

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...

Read More...




Sponsored Links




Read Next: SQL , to get consecutive same att_id



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe