Skip to Main Content
Oracle and Open Source
book

Oracle and Open Source

by Andy Duncan, Sean Hull
April 2001
Intermediate to advanced content levelIntermediate to advanced
432 pages
13h 2m
English
O'Reilly Media, Inc.
Content preview from Oracle and Open Source

ViennaSQL

ViennaSQL is another superb open source Java GUI tool that provides numerous Oracle SQL data drill-downs into the database. It is useful for both developers and DBAs. ViennaSQL comes with a GNU license, excellent functionality, and the very latest Java look-and-feel.

The following are the main web sites for ViennaSQL:

http://sourceforge.net/projects/vienna/

The development project web site

http://vienna.sourceforge.net

ViennaSQL’s general web site

Early in 1999, Mike Wilson was working on a large project with Oracle on the back end, and he needed a GUI query tool to overcome the limitations of the character-based SQL*Plus. He originally wrote a server-based tool in Tcl/Tk, but this X-based tool wasn’t up to doing the job over slow international connections—hence the need for a local client that could work on various operating systems. In order to both brush up on his Java skills and get the tool he needed—and in the tradition of many other open source developers—Mike decided that necessity was the mother of invention. He started building his tool in July 2000, with plenty of helpful advice from Andrei Lenki.

By September of 2000, an early version of the GUI query tool was available. It was originally known as vsql (Visual SQL), but because an earlier tool had the same name, Mike renamed the program ViennaSQL both to keep the “V” and to follow a personal tradition of naming server hosts after famous cities. (The famous 1980s song by Ultravox had absolutely nothing to do ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Procure-to-Pay Guide

Oracle Procure-to-Pay Guide

Melanie Cameron
Expert Oracle Exadata

Expert Oracle Exadata

Kerry Osborne, Randy Johnson, Tanel Pöder
Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Achieving Extreme Performance with Oracle Exadata

Achieving Extreme Performance with Oracle Exadata

Rick Greenwald, Robert Stackowiak, Maqsood Alam, Mans Bhuller

Publisher Resources

ISBN: 0596000189Catalog PageErrata