Re: -> User-Friendly SQL Editor? Where? <-
Date: 1996/10/21
Message-ID: <54gnll$pu2_at_nadine.teleport.com>#1/1
- 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 ...
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
>------------------------------------------------------------------
>
Received on Mon Oct 21 1996 - 00:00:00 CEST