Posted 02/02/2008 - 13:43 by Dirk
Sitting in the Oracle course I get more and more in touch with SQL and its varieties Data Manipulation Language, Data Definition Language (DDL), Data Control Language (DCL) and Transaction Control Language (TCL).
But its very cumbersome to use the iSQL*Plus web front-end to write and execute all the queries. So I did some research and found SQL Explorer. This is a very powerful, cross-platform and cross DB client for SQL databases. Just unzip it, define the jdbc jar for your database and connect the system. Ready!
Its really easy to
- connect any database you have an JDBC driver for,
- traverse the database structure,
- examine the contents of tables,
- execute queries,
- run previous queries once more,
- export data into text, html or excel files,
- and much more.
And: Its a Eclipse RCP application!
