Re: SQLPLUS training, why?

  • From: William Robertson <william@xxxxxxxxxxxxxxxxxxxx>
  • Date: Thu, 30 Dec 2010 11:45:25 +0000

You can have blank lines within PL/SQL blocks anyway, so SQLBLANKLINES isn't needed. Which reminds me, a thing that drives me crazy is when people place a "--" in every blank line of PL/SQL code for no obvious reason except to defeat vi/vim block navigation commands (curly bracket).

Not sure if it's been mentioned, but installation and release scripts for application code generally use SQL*Plus, and on a lot of sites it's the DBA who has to run them so it's worth DBAs being familiar with the tool.

For SQL*Plus on Windows (sqlplus.exe) I like to set the window title using "host title" (idea from Tanel Poder) rather than changing the SQL> prompt, as prompts more than three characters long mean multi-line queries won't line up.


Nuno Souto
30 December 2010 09:11

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


Goulet, Richard
29 December 2010 13:13		 

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!

Nuno Souto
29 December 2010 08:38

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



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!


Kellyn Pedersen
28 December 2010 15:10

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!" :)
 

Kellyn Pedersen

Sr. Database Administrator

http://www.linkedin.com/in/kellynpedersen

www.dbakevlar.com

 



From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tue, December 28, 2010 7:07:11 AM
Subject: Re: SQLPLUS training, why?

But I think that Kellyn's point was that improper use of regular expressions is the source of many clbuttic errors ...


On 12/28/2010 02:24 PM, TESTAJ3@xxxxxxxxxxxxxx


Stephane Faroult
28 December 2010 14:07

But I think that Kellyn's point was that improper use of regular expressions is the source of many clbuttic errors ...


On 12/28/2010 02:24 PM, TESTAJ3@xxxxxxxxxxxxxx

Other related posts:

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