I am using oracle sql developer . Whenever we run any table / view sql with blank lines in between, the sql developer ignores it and executes the query perfectly. The feature is good, problem is the query fails in actual deployment where sql plus is used.
So is there a way we can let SQL DEveloper throw error when there is line break in between ?
Sample :
“CREATE OR REPLACE VIEW vw_test AS
SELECT
*
— blank line
from test”
The above query runs fine in sql developer , but fails in sql plus.
Version used :21.4.1.349.1822