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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: A simple newbie question with select

Re: A simple newbie question with select

From: Tomislav Petrovic <t.petrovic_at_inet.hr>
Date: Thu, 8 Jan 2004 17:49:43 +0100
Message-ID: <btk1n4$gna$1@garrison.globalnet.hr> 






Or in other words:



How can I write this query inside stored procedure



SELECT local_id, remote_id FROM SYNCML_MAPS WHERE idn_id = a_db_idn AND


   local_id IN (1, 3, 9, 17, 20001);



So that (1, 3, 9, 17, 20001) part can be specified as procedure input
parameter???



Tomy.
Received on Thu Jan 08 2004 - 10:49:43 CST












Original text of this message













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