Re: How to pass varchar as WHERE field IN param
Posted by:
Rick James
Date: August 05, 2016 04:46PM
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.
Subject
Written By
Posted
Re: How to pass varchar as WHERE field IN param
August 05, 2016 04:46PM
September 04, 2016 02:42PM
September 06, 2016 07:48AM
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.