Query Issue in sql

Question

I am not able to execute this query getting

ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"

select count(user_id) 
from t_user 
where user_id = 2699478, object_id = 1329 
  and user_id not in
      (SELECT owner_user_id FROM t_obj where actual_id = 17447);

Can only only guess what you intended the query to do but the comma after user_id=2699478 is the problem, could be an AND or OR?? — Tony Hopkinson
– Tony Hopkinson, Commented Jun 20, 2012 at 15:54

Barry Kaye · Accepted Answer · 2012-06-20 15:54:07Z

5

You have to replace the comma , between the two conditions user_id=2699478 ,object_id=1329 with a proper conditional operators, and use parentheses to express them the way you want, like this:

SELECT COUNT(user_id) 
FROM t_user 
WHERE user_id = 2699478 
  AND object_id = 1329 
  AND user_id NOT IN
    (
        SELECT owner_user_id 
        FROM t_obj 
        WHERE actual_id = 17447
    )

edited Jun 20, 2012 at 15:54

Barry Kaye

7,7696 gold badges46 silver badges65 bronze badges

answered Jun 20, 2012 at 15:50

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Barry Kaye · Accepted Answer · 2012-06-20 15:50:38Z

4

Try replacing your comma with AND:

select count(user_id) from t_user where user_id=2699478 AND object_id=1329 and user_id not in
  (SELECT owner_user_id FROM t_obj where actual_id = 17447);

answered Jun 20, 2012 at 15:50

Barry Kaye

7,7696 gold badges46 silver badges65 bronze badges

Comments

aF. · Accepted Answer · 2012-06-20 15:50:48Z

3

Replace a comma by and:

select count(user_id)
from t_user
where user_id=2699478
  and object_id=1329
  and user_id not in (SELECT owner_user_id FROM t_obj where actual_id = 17447);

answered Jun 20, 2012 at 15:50

aF.

67k45 gold badges141 silver badges201 bronze badges

Comments

ewein · Accepted Answer · 2012-06-20 15:54:46Z

1

You need to replace the comma with an "AND":

SELECT count(user_id) FROM t_user WHERE user_id=2699478 AND object_id=1329 AND user_id NOT IN
      (SELECT owner_user_id FROM t_obj WHERE actual_id = 17447);

answered Jun 20, 2012 at 15:54

ewein

2,7456 gold badges40 silver badges57 bronze badges

Collectives™ on Stack Overflow

Query Issue in sql

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related