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: Problem in SELECT ... WHERE ... IN

Re: Problem in SELECT ... WHERE ... IN

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Sun, 14 Mar 1999 15:08:44 +0100
Message-ID: <36ebc2ee$0$28928@pascal> 





lamtse wrote


>   string_1 := ''''||'KG'||''''||','||''''||'GD'||'''';





Uwe Scheider already explained why Oracle doesn't do what you'd like it to
do. I just want to add that the line above can be replaced by



    string_1 := '''KG'',''GD''';



This does not solve your problem though.



Arjan.


Received on Sun Mar 14 1999 - 08:08:44 CST












Original text of this message













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