Fwd: Problem with SQL coming from SQL Server into Oracle DB
- From: nigel.cl.thomas@xxxxxxxxxxxxxx
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Jun 2008 16:01:23 +0100
2008/6/26 Sandra Becker <sbecker6925@xxxxxxxxx>:
> Something I forgot to mention earlier is that SSRS always puts an "N" in
> front of each value in the "IN" clause and we have to strip that out before
> we run it from sqlplus.
>
That could be your problem. N'string' uses the national language char set
and collation - so a simple index on the column might not be used; are you
seeing an implicit cast of your column to NCHAR or NVARCHAR?
See SQL Ref Guide: Literals
<http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements003.htm#i42617>
Regards Nigel
Other related posts:
- » Fwd: Problem with SQL coming from SQL Server into Oracle DB
