SQL-Plus and vertical spacesLet’s see a simple query I had to submit thru
Is the above query correct?
UPDATE foo SET status = 200 WHERE id IN ( 123, 456, ... 999 );
*Yes, it is good because *SQL is space-agnostic ** and therefore both horizontal and vertical spaces do not matter.
Unless you are using
sqlplus, that considers the above a broken query because for some odd reason does not want an empty line. And in fact, removing the empty line before the first
INvalue fixes the problem.