Tip : Database Query Tool for Oracle 8i,Oracle 9i,Oracle 10g with Free Aqua Data Studio 4.7

Forgot the SQL Plus in oracle from now.

I'm proud to present the professional database query tool "Aqua Data Studio 4.7" that free for developer and student.

I my opinion ,i think i success for develop software with oracle database ,the key for success is quickly development "Aqua Data Studio 4.7" can save a lot of time for development, so i love it.

This tip i want to share the best and valuable experience in hard working.

The first,i will take you tour "Aqua Data Studio 4.7" feature.

1.)Aqua Data Studio run on Window XP,Windows Vista,Mac OS,Linux,Solaris and Java Plateform Enabled

2.)Aqua Data Studio working on Oracle 8i,Oracle 9i and Oracle 10g.

3.)Include Oracle Database Administration (DBA) Tools following Instance Manager, storage
Manager, Rollback Manager, Log Manager, Security Manager, Session Manager, GA Manager, Server Statistics

4.) Visual Query Builder allows users to graphically select tables, views and relationships to build queries. this feature will save your time.

5.) Super Auto-completion is a hight light feature of Aqua Data Studio

6.) SQL Formatter (Beautifier)

7.) Parameterized Scripts

8.) Shortcut Toolbar

9.) Schema Browser Filtering

10.) Mountable Server Connections

11.) Query Analyzer: Changable Schema Context (Oracle & DB2)

12.) Query Analyzer Permissions

Wow .. those are "Aqua Data Studio 4.7" features .

Next, we will explain how to install and configuration "Aqua Data Studio 4.7" with Oracle 8i,Oracle 9i,Oracle 10g

Download "Aqua Data Studio 4.7"


Aqua Data Studio 4.7


System requirement before installation:
- Java Runtime Environment 1.5 or above
- Operating System Windows XP, Windows Vista, Linux, Mac OS and Java Platform Enabled

You can install with two choices:
- with installer (.exe in windows)
- without installer extract to driver (.zip or .tar.gz)

Install "Aqua Data Studio" in general step by click and click ..
Notice :
For User & License dialog :
in "Usage" select "Personal Use - Personal use for leaning purpose"
in "Personal License" select "I verify that my use ..." and type "YES" in text box


Picture 1. How to chose Personal License in Aqua Data Studio 4.7

for this step finish to installation "Aqua Data Studio 4.7" , but you need to check your oracle version before open "Aqua Data Studio 4.7"

for oracle 10g you can start "Aqua Data Studio 4.7"
for oracle 9i you can start "Aqua Data Studio 4.7"

for oracle 8i you must copy ORACLE_HOME/jdbc/classes12.zip to AQUA_DATA_STUDIO_HOME/lib and change AQUA_DATA_STUDIO_HOME/datastudio.cfg by see "oracle.jar" and replace with "classes12.zip"

------- original datastudio.cfg ------
-Dsun.swing.enableImprovedDragGesture -Xmx256M -cp ".\lib\ads.jar;.\lib\aqua-lib.jar;.\lib\jnlp.jar;.\lib\oracle.jar;.\lib\nlscharset12.jar;.\lib\jtds.jar;.\lib\mysql.jar;.\lib\postgresql.jar;.\lib\db2java.jar;.\lib\db2jcc.jar;.\lib\db2jcc_license_cu.jar;.\lib\ifxjdbc.jar;.\lib\jconnect55.jar;.\lib\jconnect60.jar;.\lib\xmlparserv2.jar;.\lib\xdb.jar" com.aquafold.datastudio.DataStudio
------- change to ---------
-Dsun.swing.enableImprovedDragGesture -Xmx256M -cp ".\lib\ads.jar;.\lib\aqua-lib.jar;.\lib\jnlp.jar;.\lib\classes12.zip;.\lib\nlscharset12.jar;.\lib\jtds.jar;.\lib\mysql.jar;.\lib\postgresql.jar;.\lib\db2java.jar;.\lib\db2jcc.jar;.\lib\db2jcc_license_cu.jar;.\lib\ifxjdbc.jar;.\lib\jconnect55.jar;.\lib\jconnect60.jar;.\lib\xmlparserv2.jar;.\lib\xdb.jar" com.aquafold.datastudio.DataStudio

Save and Close edit datastudio.cfg and Start "Aqua Data Studio 4.7"

Congratulations!! ,You can use "Aqua Data Studio 4.7" for Oracle 8i,Oracel 9i and Oracle 10g

Next Step we will create group and register oracle server with oci :

Right click on "Oracle Database Server" menu and Select "New Server Group" ,New Server Group dialog are displayed ,type any your group for example "oracle database group"


Picture 2. Create New Server Group

Right click "oracle database group" and select "Register Server"


Picture 3. Create Group Name

Type oracle connect info to "Register Server" Dialog


Picture 4. Setup "Register Server"

When you finish on this step ,try to connect .

In "Server Menu" select "Query Analyzer" and put your SQL for test Query.

Picture 5. Query Analyzer Tools with Super Auto Completion
And another tools in "Server" menu for example Query Builder


Picture 6. Query Builder Tools for Create SQL with GUI

I think this experience are useful for many people and save a lot of time for develop software with oracle database (oracle 8i,oracle 9i,oracle 10g).

Note : Enjoy with made easy.
Today's Joke :
SQL Plus is devil because killer your time.