Re: can someone please check my sql ??

Hello, Andrew,

I'm wondering about the use of double-quote characters in the LIKE phrase near the bottom. I always use the single quote character '.

---
Paul

OEM wrote:

> hi
>
> could any sql oracle guru out there please help me out of this misery and
> tell me if he/she sees any error in the following sql statement:
>
> SELECT INV.INV_SYSTEM.SYS_NAME, INV.INV_EUP_AUFSYS_V.ES_AUF_ID,
> INV.INV_SYSPAR.SP_VALUE FROM (INV.INV_SYSTEM INNER JOIN
> INV.INV_EUP_AUFSYS_V ON INV.INV_SYSTEM.SYS_ID =
> INV.INV_EUP_AUFSYS_V.ES_NEW_SYS_ID) INNER JOIN INV.INV_SYSPAR ON
> INV_EUP_AUFSYS_V.ES_NEW_SYS_ID = INV.INV_SYSPAR.SP_SYS_ID WHERE
> (((INV.INV_EUP_AUFSYS_V.ES_AUF_ID)=[MIG_ID:]) AND
> ((INV.INV_SYSPAR.SP_VALUE) LIKE "ts01%"));
>
> I should use this to connect via ODBC on NT to a oracle 7 db
> but I always get strange errors like "missing key SELECT STATEMENT" and
> such stuff.
>
> Do you think the command is compatible with oracle the way it is written
> now ?
>
> thanks a lot in advance,
>
> andrew
Received on Mon Sep 20 1999 - 17:12:15 CDT