Re: dynamic join view

"Jetlag" <jetlag11235_at_yahoo.com> wrote in message news:2eeed00e.0310221400.5b63f694_at_posting.google.com...
> I seem to recall a colleague talking about a way to statically define
> a join view in such a way that tables not needed to satisfy a given
> select statement do not participate in the join process. If memory
> serves me, PL/SQL functions played some kind of role here. This
> wasn't some kind of magical solution ... there was some overhead to
> doing things this way -- in particular, one would not want to query
> this view if it were known ahead of time that all tables in the view
> are needed.
>
> If anyone knows of a method to do this, I would greatly appreciate the
> help. Thanks.
>
> -- jetlag --

Not sure what you mean by statically defining a join view. What you can do is to pass parameters and then based on the input parameters, build a sql string and execute it dynamically.

Things to read .. ref cursor, dynamic sql .....

Anurag Received on Wed Oct 22 2003 - 21:45:57 CDT