SQL Command Not Properly Ended (ORA-00933)

From: <steve_dennis_at_my-dejanews.com>
Date: Fri, 21 Aug 1998 20:13:30 GMT
Message-ID: <6rkkda$9tu$1@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:13:30 CDT