Re: Query Help

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 26 Jan 2007 09:00:22 -0800
Message-ID: <1169830820.259394@bubbleator.drizzle.com>

AZNewsh wrote:

> On Jan 25, 4:42 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> AZNewsh wrote:
>>> That will not 'get me going'
>>> That is not what i asked, I asked for help with the conceptual query
>>> and what the heck is top posting?
>>> On Jan 25, 2:04 pm, "Ed Prochak" <edproc..._at_gmail.com> wrote:
>>>> On Jan 25, 1:26 pm, "AZNewsh" <g..._at_dana.ucc.nau.edu> wrote:
>>>>> Thanks but I don't think that does the same thing unless I am reading
>>>>> it wrong:
>>>>> http://www.oracle.com/technology/oramag/oracle/06-nov/o66asktom.htmlP...DON'T TOP POST!
>>>> Look at generating a pivot tablehttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7...
>>>> That should get you going.Top posting is what you just did. This forum reads from top to the
>> bottom. When replying scroll to the bottom and then reply ... do NOT
>> post at the top.
>>
>> We sent you to the solution. But if you prefer concept ok.
>>
>> Use an analytic function with LAG or LEAD integrated with either CASE or
>> DECODE to pivot the data.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -- Show quoted text -

> 
> That's very helpful to a person who is inexperienced and trying to
> learn, however if that s how you get your kicks - enjoy

Let me see if I understand you; please.

We provide you with a complete answer to what you asked and you complained: "I asked for help with the conceptual query" and now you have that and you still are not happy.

Are you actually requesting that someone write it for you? If so please state that clearly. Perhaps it is just the fact that we think in terms of language having meaning ... but I don't interpret the word "help" as equal to "write working code for me." I interpret it as "please point me to the functionality I should use and I'll figure it out myself."

You are getting what you asked for. If it is not what you want then please be clear. Do you want someone to do your work for you?

-- 
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 Fri Jan 26 2007 - 11:00:22 CST