CODEWITHSUNDEEP
oracle-database
Peacepanda
Peacepanda

Reputation: 11

ERROR at line 1:ORA-00933: SQL command not properly ended

Hi I have the following table and I am running the follwoing query in it.

Table Name:MMC

Command that I am running is 

SELECT REM_Q FROM MMC  where CLIENTQ = AJIT AND SENDER_SYSTEM = NEWYORK;

I am gettng the above error. Can someone please tell me what is that I am doing wrong here.

Upvotes: 1

Views: 354

Answers (1)

Petr Mensik
Petr Mensik

Reputation: 27496

What columns are AJIT and SENDER_SYSTEM? If they are VARCHAR then you should wrap parameters in quotes like 'AJIT' and 'NEWYORK'.

Upvotes: 5

Related Questions