RE: SQLPLUS training, why?

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <dbvision@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Dec 2010 08:13:32 -0500

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!

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010