Re: tools for PL/SQL development

"Andrew Hardy" <junkmail@[127.0.0.1]> wrote in message news:c158a0$hh8$1_at_sun-cc204.lut.ac.uk...
| Karsten Schmidt wrote:
|
| > Hi,
| > IMO, using tools like Toad etc is far too dangerous in the hands of
| > developers,
| > this is really just point and click, and oops, accidently dropped a
| > trigger i didn't mean to, or changed a stored procedure in-line,
| > without checking the modification into revision control.
|
| Well, if you can't rely on your developers to not drop code willy-nilly
| then forcing them to only use SQL*Plus isn't going to make much
difference.
|
| >
| > these kinds of mishaps more than outweigh the gain from not having to
| > type
| > if- then- else or procedure declarations.
| >
| > productivity does not nessecarily come from using fancy "easy" tools.
| >
| > Karsten
| >
| >
| > Andrew Hardy <junkmail@[127.0.0.1]> wrote in message
news:<c14ser$f0o$1_at_sun-cc204.lut.ac.uk>...
| >
| >>Pete Finnigan wrote:
| >>
| >>
| >>>In article <1077236289.2191_at_yasure>, Daniel Morgan
| >>><damorgan_at_x.washington.edu> writes
| >>>
| >>>
| >>>>Cris Carampa wrote:
| >>>>
| >>>>
| >>>>
| >>>>>My boss wants me to evalutate tools for enhancing productivity in
PL/SQL
| >>>>>development, like TOAD or Embarcadero SQL Debugger, but I'm currently
| >>>>>happy with my "franciscan" enviroment (vi+sqlplus) :) Am I such a
| >>>>>dinosaur? Which tools are you PL/SQL developers using?
| >>>>>
| >>>>>Thank you. Kind regards,
| >>>>
| >>>>In my opinion ... stay with SQL*Plus and invest the money in getting
| >>>>some good training. The best tools on the planet don't make you more
| >>>>prouctive unless you already know what you are doing.
| >>>>
| >>>
| >>>very good point Daniel, sometimes missed by many. You do indeed need to
| >>>known what you are pointing and clicking at! - go for the gui tools
| >>>after you are comfortable with the mechanics behind what you are
| >>>actually trying to do.
| >>>
| >>>cheers
| >>>
| >>>pete
| >>>
| >>
| >>Not sure I totally agree.
| >>
| >>The OP was talking about PL/SQL development. Using SQL*Plus to do such
| >>development isn't really the ideal tool - you're looking for an
| >>environment to make a developer's life easier.
|
|
| --
| Andy - Opinions are mine and do not necessarily reflect those of
| Advantica Ltd

similar things were said about the steam engine...

the advise to stick with SQL*Plus until you know what you're doing is good for only about the first 10 minutes of your Oracle career

yes, you need to know how SQL*Plus works, and you need to understand the what the SQL is doing, but where is the advantage to using vi/notepad and SHOW ERRORS rather than an honest-to-goodness programmer's editor that highlights keywords and syntax (so you can easily see where you forgot to terminate a string) and highlights the error locations?

learning SQL and using a GUI tool are not mutually exclusive, and there is no inherent virtue in vi -- i think the point that should be made is do not rely on a gui to generate SQL that you don't understand, but by all means, use the tools that make your life simpler, but use them responsibly

;-{ mcs Received on Fri Feb 20 2004 - 11:07:18 CST