Re: tools for PL/SQL development

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