Re: SQL Command Not Properly Ended (ORA-00933)

Well, your first problem is that Oracle uses single-quotes for string literals, not double quotes...

As to why it works in the Access Pass-Through window with the double quotes but no semicolon, I have no idea.

steve_dennis_at_my-dejanews.com wrote in message <6rkkda$9tu$1_at_nnrp1.dejanews.com>...
>I get the error message in the subject line (ORA-00933) when I type the
>following query in SQL*PLUS or MS Access SQL Pass-Through window:
>
>SELECT * FROM DW_PROD.MEMBER_HISTORY AS A
>WHERE A.SUBSCRIBER_ID = "0094100006";
>
>But not if I have no WHERE clause. The query works without a WHERE CLAUSE
in
>the Access Pass-Through window if I omit the semi-colon; I must use the
>semi-colon in SQL*PLUS. Why must I terminate the SQL statement differently
>depending on the statement?
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 21 1998 - 15:29:26 CDT