Re: Need SQL Server Temp Table equivalent (challenge!)

Galen,

Thinks for looking very detail in my example. You are right I can't do a stright Select * from MyView in Oracle. If I have to do that in SQL Server, I have to call the SP to get the same result. I was just trying to illustrate what I want. I was hoping the Table Function of something that allows me to do something to that effect.

If you never need a temp table in Oracle, can you suggest how I can do that in Oracle without temp table?

point out my
Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<usmoyny3n.fsf_at_standardandpoors.com>...
> On 17 Jul 2003, kin_ng5_at_yahoo.com wrote:
>
> > I studied the pipelined function and table function and found
> > that each required a **pre-defined" type for the return. The
> > key for my need is variable columns, not pre-defined.
> >
> > e.g. I want to return 2 columns by doing this:
> >
> > Select * from MyView
>
> How does a view point to a temporary table? It seems that in
> SQLServer you would need a stored procedure to accomplish what
> you are doing here.
>
> You could do the same thing with cursor processing in Oracle. It
> doesn't seem that the temporary table buys you much of anything
> because you still need to do cursor processing?
>
> Maybe I'm missing something? Does SQLServer allow a view to
> represent the execution of a stored procedure? Oracle doesn't
> allow this, but it does allow a function to be executed which
> might mimic a view.
>
> It seems that the "view representing a stored proc" might be the
> more lacking feature. I've never needed a temporary table since
> I left Sybase for Oracle and I used to be a temporary table
> bigot.
Received on Tue Jul 22 2003 - 20:38:02 CDT