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

Home -> Community -> Usenet -> c.d.o.server -> Re: Fine points on analytic functions

Re: Fine points on analytic functions

From: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Tue, 09 Nov 2004 16:14:01 GMT
Message-ID: <d16kd.134543$df2.114569@edtnps89> 





Roger Redford wrote:


<snip>


> The problem is, I could not get the case statements 

> to work in a stored procedure in version 817.  

> 

> Am I incorrect on this?  Is there a way to use the

> case statements in 817?  




Only in dynamic sql, in 817, or using DECODE etc



> 

> Will case statements work in stored procedures in 9?

> 



yes



<snip>
Received on Tue Nov 09 2004 - 10:14:01 CST












Original text of this message













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