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: How to get "...WHERE test IN (5,23,2,12,56)" in this order

Re: How to get "...WHERE test IN (5,23,2,12,56)" in this order

From: andrija <ar35644_at_fer.hr>
Date: Thu, 10 Jan 2002 14:00:56 +0100
Message-ID: <a1k3b4$e2ah$1@as201.hinet.hr> 





> Andrija,

>

> thank you!!

> May not look that elegant but is a perfect workaround for me.

> (Why isn't there a possibility inside Oracle or a predefined function...?)

>

> greetings, Dirk




That's why there are user-defined functions. Oracle can not predict all
functions that you might need. So, you can write them yourself.



Don't let me start about SQL Server, in 7.0 there were no user defined
function, this problem would be solved with two stored procedures and a
temporary table... But that's another story.
Received on Thu Jan 10 2002 - 07:00:56 CST












Original text of this message













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