Invalid completion of the SQL statement

Question

Invalid completion of the SQL statement

There is a request SELECT * FROM SMSPECREFUSE WHERE REASON= 'Недопоставка' It works correctly and outputs what you need. If I add to the request SELECT * FROM SMSPECREFUSE WHERE REASON= 'The failure to deliver', 'Excess application', 'Mismatch price', 'No request', 'Marriage', 'item Exchange', 'Short time', 'Failure to follow orders', 'not ready for public consumption' at the end of the error:

1

sql oracle11g

Author: Илья Евтропов, 2020-02-27

Source

1 answers

score 1 · Accepted Answer

SELECT * FROM SMSPECREFUSE WHERE REASON IN (
  'Недопоставка', 'Превышение заявки', 'Несоответствие цены', 
  'Нет в заявке', 'Брак', 'Обмен товара', 'Короткий срок', 
  'Невыполнение заказов', 'Нетоварный вид'
)

SELECT * FROM SMSPECREFUSE WHERE 
  REASON = 'Недопоставка' OR
  REASON = 'Превышение заявки' OR
  ...