Re: Alternative to SQL*Plus - SQL Studio 2.0 description

In <ks.82.00251DCF_at_ic.uva.nl>, ks_at_ic.uva.nl (Karel Sprenger) writes:

>In article <2ufoga$2o9_at_uuneo.neosoft.com> chadb_at_NeoSoft.com writes:
>
>>In <2ubu8a$8io_at_reeve.research.aa.wl.com>, lee09_at_aa.wl.com (Wilson Lee) writes:
>>>I'm just getting up to speed with Oracle, and I was just noticing how
>>>user-unfriendly SQL*Plus 3.1.1.9.3 on Windows is.  Is there anything
>>>out there (public domain preferably, but it's probably a long shot) 
>>>that has a facility for attaching macros to key combinations and can
>>>completely replace Windows SQL*Plus running on SQL*Net TCP/IP?
>>>
 

>>Well, I got a product called SQL Studio from Stanford Technology.  {snip}

>>Worth a look.....
>
>How much does it cost and where can I reach Stanford Technology? About the 
>only thing that can be said about SQL*Plus 3.1 for Windows is that it works...
>

OK, here goes... From the SQL Studio 2.0 advert. they sent me....

Object Map -

• Graphically browse schema and database objects
• Drill down by double clicking
• Copy entire objects
• Delete objects
• Launch an editing session by double clicking

Graphical Object Editors

• Specialized visual editors for Oralce7 Objects including:
  • Tables, indexes, constraints, Views, Roles and Grants, Sequences...

Graphical Table Editor

• Column names, types, lengths
• Table and column comments
• Oracle storage parameters
• Primary key, foreign key, unique, check, and not null constraints

Role Manager

• Grant and Revoke users to roles
• Grant and Revoke system privileges to users and roles
• All grants via siple drag and drop

Programming Features

• Supports all Oracle7 programming constructs, including procedures, functions, packages, package bodies, and triggers
• Interactively compile source code
• Check in/out for team development
• Full source code editor
• Revert to last saved version
• View compilation errors
• Click on error explanation and jump to source with error
• Get more info, such as code size and last DDL modification
• Cut, copy, paste between windows and other applications
• Drop-down boxes for quick navigation to any object
• Instantly enable/disable triggers with click of check box
• Unique DBMS Output Window

Pop-Up SQL Assistant

• Look up names(and arguments if desired) and drop them directly into your source code with a mouse click

Explain Plan

• Graphical representation of SQL execution paths
• Support multiple users in central plan file
• Save plans with comment for easy comparison

Scripts

• Execute any SQL script
• Multiple Execute SQL Windows open concurrently, with seperate cursors to Oralce
• Save most recent scripts for quick access

The best of Windows {editors note : cheese fluf}

• Commonly used functions available on handy toolbar
• Context-sensitive, on-line, Windows help
• Smart client-server design

Importing and Exporting SQL

• Generate SQL DDL selectively for database objects, for all or part of schema
• Import SQL

Reports

• All code by schema
• Tables with Triggers
• Dependencies
• Compilaton errors
• ...

System Requirements

• PC, Win 3.1, 4Meg disk, 8Meg(total) memory, SQL*Net for Windows.
• Oracle7 release 7.0.12 or later with procedural optioin

  ---

Looks pretty sweet, has a lot more than 1.0 had. Stanford Technology Group, Inc., Phone : 415-247-6540. The price is (I'm pretty sure) $495.

  Chad

--
Chad Brockman            | 
VertiComp, Inc           | I'm just an OS/2 Junkie!!
chadb_at_NeoSoft.com        | "Come on kid, it's cheap!!"