Re: Complex logic query that I cannot figure out:(

hpuxrac wrote:

>> You have two choices:
>>
>> 1. Use Native Dynamic SQL
>> 2. Write an IF statement that, based on the parameters supplied,
>> chooses one path or the other
>>
>> Try both ... choose one.

> 
> A better approach might be to use plsql ( that can see which
> parameters are used ) and return a ref cursor

That's #2. IF statements, are, by definition, PL/SQL.

Yes that's me shaking my head in amazement.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org