Martin T. wrote:
> DA Morgan wrote:
>> Martin T. wrote:
>>
>>> When will they give me templates for my packaged SQL?!? :)
>>>
>>> cheers,
>>> Martin
>> Please explain ... off-line if you prefer.
>>
>
> Hu? Off-line?
>
> It's just a fancy idea of mine ...
> So we have VIEWS ... which are stored queries to make things more
> organized.
> Why not have more flexible "views" where part of the "view" remains
> variable until used ... so that the user of the view could push
> predicates or whatever into the view ... the SQL engine wouldn't even
> be aware of it, just the PL/SQL compiler.
> Or at least give me packaged views ... cursors are alright but they're
> so awful to use in PL/SQL code compared to inline queries ... (And I so
> hate having to define everything on the schema level.)
>
> Well. Just my 002. I'm sure you disagree ;-)
>
> cheers,
> Martin
I don't disagree. But how is this different from putting a pipelined
table function with NDS into a package?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Oct 28 2006 - 12:42:56 CDT
