UPDATE products SET quantity = to_number( SELECT CASE WHEN (quantity - 51 ) < 0 THEN 'Error Out Store' ELSE to_char(quantity - 51 ) END FROM products WHERE proid = 16 ) where proid = 16
ERROR - java.sql.SQLException: ORA-00936: 缺少表达式帮忙看看
ERROR - java.sql.SQLException: ORA-00936: 缺少表达式帮忙看看
UPDATE products
SET quantity =
(SELECT TO_NUMBER (CASE
WHEN (quantity - 51) < 0
THEN 'Error Out Store'
ELSE TO_CHAR (quantity - 51)
END
)
FROM products
WHERE proid = 16)
WHERE proid = 16
SET quantity =
TO_NUMBER (CASE
WHEN (quantity - 51) < 0
THEN 'Error Out Store'
ELSE TO_CHAR (quantity - 51)
END
)
WHERE proid = 16