Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible Use of a Cursor

Re: Possible Use of a Cursor

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 23 Feb 2005 00:23:27 -0800
Message-ID: <1109147007.008568.278270@o13g2000cwo.googlegroups.com>


Casey,

  I tried your suggestion and it looks like it should work. However I get the error message ORA-00933 command not properly ended. The cursor highlights the beginning of the 2nd SELECT statement. The error message has something to do with using the ORDER BY function. I took out the ORDER BY (which defeats the purpose of using the FIRST_VALUE function) and get the same problem.

  Here's a copy of what I have written:

  select papp.INSTRUCTION_NR,papp.MACHINE_PROC,papp.POSITIONS_NR   from w100.papp
  (select first_value(papp.MACHINE_PROC)   over (partition by papp.INSTRUCTION_NR order by papp.POSITIONS_NR)   first_MACHINE_PROC from tab)
  where papp.MACHINE_PROC in (3600,3400,3430) Received on Wed Feb 23 2005 - 02:23:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US