SET SQLBLANKLINES

[aotte]

Hi,

Could we get support for the SET SQLBLANKLINES [ ON | OFF ] option in the command window?

The majority of the code I need to support is a mixture of PL/SQL and SQL scripts, that use blank lines within SQL statements.

Thanks.

Arnoud.

------------------
Hakuna Matata,

Arnoud.

 

[Marco Kalter]

I have added this to the list of enhancement requests. It seems doable, and maybe we can add this in a patch release.

------------------
Marco Kalter
Allround Automations

 

[aotte]

Hi Marco,

That would be awesome. That way I have absolutely no reason at all anymore to visit SQLNav.

Looking forward to it.

Arnoud.

------------------
Hakuna Matata,

Arnoud.

 

[aotte]

Hey,

I know this has already been implemented a long time ago (thank you), but I just noticed it has not been added to the user manual.

That's all.

 

[Marco Kalter]

We'll fix it

 

[Jeff Kandt]

FYI, I don't see SET SQLBLANKLINES documented in the v12 manual.

I hope it just never made it into the docs, as opposed to having been DE-supported at some point in the last 8 years...? (I haven't tested it yet.)

I've read through the Command Window chapter of the manual quite a bit lately, and would have never known this command exists (not a SQL*Plus expert) except that I happened to spot it being used in someone's example script in a recent forum post, which prompted me to look it up.

We've had deployments fail recently because of blank lines in scripts, and this should really help us.