Re: Select Function Returning Results of Select on Tables

Your answer is what is appalling. And, to top it off , aren't you an instructor?

I have kids and I always tell them that they should always ask questions if they are unsure about something and that there are no such things as "stupid questions". You must really make your students "feel stupid" . Do you get ANY questions after the first day? Just wondering...

You could have phrased your response a lot differently. Instead, you immediately went into "critic mode".

Please do not try to "help me" anymore.

Thanks.

-- 
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1064985255.73616_at_yasure...


> Burt Peltier wrote:

>

> >I did search Google before this. I don't see any example that does what I

> >would like to do. I saw some things that are close.

> >

> >I would like to create a function that I can select which does some

> >processing to create a global temporary table and then returns a select

on


> >the global temporary table.

> >

> >I am running Oracle 8.1.7.4 on Solaris 8 .

> >

> >

> >

> You stated what you would like, above. I would like to convince you that

> this is about as poor an idea,

> from the standpoint of scalability, performance, design, and

> architecture as you could put on a wish list.

>

> I can not conceive of a single valid reason to do this and my instinct

> is that it betrays a complete lack of

> understanding of Oracle architecture, what GTT's are, and how they

> should be used.

>

> So rather than help you do something so apparently appalling I would

> suggest you tell us what the probelm

> is that you are trying to solve and let us suggest a better way to solve

it.


>

> Sorry if this was a bit harsh ... but I wanted you to get a flavor for

> how it struck me and I think the above is

> a fair representation.

>

> -- 

> Daniel Morgan

> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

> damorgan_at_x.washington.edu

> (replace 'x' with a 'u' to reply)

>