Re: -> User-Friendly SQL Editor? Where? <-

jmiles_at_technosolutions.com (Jim Miles) wrote:

>
>Have you read the latest Oracle Integrator (Sept/Oct '96) ?
>It has a product review of SQL Navigator.
>
>"I'm now convinced that SQL Navigator is the best PL/SQL programming
>tool currently available", Tom Cox, Oracle Integrator.
>
>Check it out yourself ...
>
>* SQL editor with color syntax hilighting and printing.
>* SQL Wizard to build SELECT, INSERT, DELETE, UPDATE
> statements with minimal typing.
>* SQL catalog to save your frequently used SQLs
>* Support for substitution variables (&, && and DEFINE etc.)
>* Rows for SELECT stmt are returned in a spreadsheet format.
> And you can even edit the data!
>
>* 14 different visual object editors including Procedure/Trigger
> editor with color syntax hilighting and printing.
>* "Drag and Drop" coding (You can drag and drop PL/SQL syntax,
> SQL functions, column names, any object name into your code)
>* Programmable keys (Pre-programmed with PL/SQL code!)
>* Support for "Server output".. So you can debug using DBMS_OUTPUT package
>* Check-in/Check-out for team programming support
>* Intuitive hierarchical database navigator
>* Top notch graphical "Explain Plan" utility ...
>
>Find out why Andersen consulting upgraded to a site license of
>SQL Navigator from another tool ... check it out for yourself.
>
>Download SQL Navigator from http://www.technosolutions.com
>or call 360-260-0710 to get your free trial copy.
>
>Jim Miles
>TechnoSolutions Corp.
>Oracle business alliance programme
>
>In article <53r34p$gve_at_is04.via.at>,
> dtr_at_leadingbits.via.at (Dieter Oberkofler) wrote:
>>"Shawn Odekirk" <shawno_at_erudite.com> wrote:
>>
>>>> I too am from a MSSQL and Sybase backround and was unimpressed with
>>>> the Oracle tools available. I still use a text editor and read files
>>>> in SQLPLUS. I will be looking at a Windows based tool from
>>>> TechnoSolutions called SQL navigator. It looks promising. The are at
>>>> http://www.technosolutions.com.
 

>>>One of my complaints with using SQL Plus to apply stored procedures from
 text
>>>files is that blank lines are stripped out of the source as it is read. If
 I
>>>get a compile error, the line number is meaningless compared to the source
 in
>>>my editor.
>>>Procedure Builder deletes source code occasionally if you get an error when
>>>compiling, so I'm staying away from that tool.
>>>If anyone knows how to get SQL Plus to maintain blank lines when you read a
>>>file (_at_, START, GET) I would appreciate knowing how.
 

>>>Thanks,
>>>Shawn
>>
>>Hi Shawn,
>>
>>Just have a look to shareware program called PLEdit (pledit.exe).
>>I found it on compuserve and it is the absolutely best PL/SQL
>>editor for oracle i ever saw. It's fast, reliable small and very
>>easy to use. I love it.
>>
>>Its written by: Mark J. Ford (103217.560_at_compuserve.com)
>>
>>You must get it!!!
>>
>>Dieter Oberkofler
>>Director of Engineering
>>
>>------------------------------------------------------------------
>>LEADING BITS GmbH. Tel (+43-1) 586 76 11
>>Schleifmuehlgasse 5/17 Fax (+43-1) 587 76 15
>>A-1040 Vienna E-mail dtr_at_leadingbits.via.at
>>Austria Compuserve 100141.1314
>>------------------------------------------------------------------
>>
>

Thank you for your information Jim,

I downloaded navigator and was quite impressed.

There are still a few things that a actually disliked:

(1) SQL Navigator is a big tool!
(2) SQL Navigator does not "only" use the native oracle api!
(3) SQL Navigator seems to have problems with 32Bit SQL*Net!

Dieter Oberkofler
Director of Engineering

LEADING BITS GmbH.               Tel             (+43-1) 586 76 11
Schleifmuehlgasse 5/17           Fax             (+43-1) 587 76 15
A-1040 Vienna                    E-mail     dtr_at_leadingbits.via.at
Austria                          Compuserve            100141.1314
------------------------------------------------------------------