Allow Blank Lines In Your SQL Statements: SQLBLANKLINES

 

use the following SQL*Plus statement: SET SQLBLANKLINES ON

This statement has two options to turn ON or OFF blank lines. If blank lines are turned on, then you are allowed to use blank lines within the lines of your SQL statement.

 

By default the blank lines are OFF, meaning it is not allowed to have blank lines within a SQL statement. Below is an example on the usage

 

SQL>show SQLBLANKLINES

sqlblanklines OFF

 

SQL>SET SQLBLANKLINES ON

 

SQL>select count(*) from dba_users

2

3 where username like 'D%';

 

  COUNT(*)

----------

        11

 

SQL>SET SQLBLANKLINES OFF

 

SQL>select count(*) from dba_users

2

3 where username like 'D%';

 

SP2-0734: unknown command beginning "where user..." - rest of line ignored.

 

You can also use a shorthand form of this command:

set SQLBL ON
show SQLBL

And that is the tip for today