Re: SQLPLUS training, why?

Thanks, very handy.
Does that work for SQL inside PL/SQL blocks?

--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxx


Goulet, Richard wrote,on my timestamp of 30/12/2010 12:13 AM:
Humm,  Looks like someone could use a review of the SQL*Plus command
reference:

SET SQLBL[ANKLINES] {ON | OFF}

This ends that problem.


Dick Goulet
Senior Oracle DBA


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nuno Souto
Sent: Wednesday, December 29, 2010 3:38 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: SQLPLUS training, why?

Kellyn Pedersen wrote,on my timestamp of 29/12/2010 2:10 AM:

Yes and then some... considering the technical level of many who will
be
attending, do you really want them playing around with regular
expressions?? I
was referring to ones who might use MSWord, Text editors and Excel
spreadsheets
to create SQL that could be easily generated inside SQL Plus. When I
picture
these folks, I would never consider just throwing them into the deep
end of the
pool with RE's and say, "Swim!" :)


If there is one thing that drives me nuts with that mob - and the
Toad/sqldeveloper one as well - it's the blank lines in between a single
SQL
statement: guaranteed to screw up a long script when run from
SQL*Plus...

I now run a vim macro through every script originating from that stable!

--
http://www.freelists.org/webpage/oracle-l


Other related posts: