Re: How to pass varchar as WHERE field IN param
Please display the SQL statement after you have built it. I suspect there are missing quotes or something.
Using IN will be faster than client code and faster than sproc code. This because it avoids reparsing, etc, the query. Such can take up to 90% of the time..but executing the query from C# which is faster and quicker solution, won't that be bad idea? and won't it slow the performance as t will run the same query X number of times?
Subject
Written By
Posted
September 04, 2016 02:42PM
September 06, 2016 07:48AM
Re: How to pass varchar as WHERE field IN param
September 04, 2016 05:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.