Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql query to find correct time diffrence
Jack wrote:
> But this cany be used inside pl/sql .... no case allowed
Interesting how this:
"sql query to find correct time diffrence"
suddenly became a PL/SQL issue. Had you mentioned that fact in your original post you would have received a working response. And you don't NEED a case statement in PL/SQL as there is if/then/else logic available to you, which is the crux of CASE, had you not noticed. If you are so impaired as to be unable to convert my query to proper PL/SQL code I suggest you start reading Steven Feuerstein's text. I've provided the logical flow and calculations; it is your job to properly implement this within the scope of PL/SQL. I will not write it for you.
David Fitzjarrell Received on Mon Dec 26 2005 - 18:39:10 CST
![]() |
![]() |