Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Query Help
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 Received on Thu Jan 25 2007 - 17:45:33 CST