Tiny Oracle Get(Oracle Viewer/Qt/Linux/Windows/GUI/Free/Tool/milu Soft)

"Tiny Oracle Get" is a Oracle DB GUI tool on Linux/Windows for developers and a free soft.
Oracle Client and Qt4 libraries are required.

CONTENTS

Download

[Introduction]

This aplication has the following features.

You can get a SQL result for Oracle DB with a table representation.
You can change an output direction of results horizontally/vertically.
Multi byte character table,column and object name are supported.
New!! Ver1.17You can add/update/delete records on Table MDI Window.
You can see updated columns with a yellow background by 'Compare SQL' button.
You can get a explain plan for any SQL.
You can save a SQL result to a Excel file.(available about 1M data for save.)
You can load a Excel file to Oracle DB.This is done by a new connection,while another functions are done by same one connection.(available about 1MB data for load.)
You can change to a favarite language(Japanese/English).(sorry, my poor english.)
You can list up all TABLE/INDEX/VIEW/MATERIALIZED VIEW/PROCEDURE/PACKAGE/TRIGGER/SEQUENCE.
You can save all TABLE/INDEX/VIEW/MATERIALIZED VIEW/PROCEDURE/PACKAGE/TRIGGER/SEQUENCE DDLs to files.
Saved file name is like this.
user_name@db_name.OBJECT.OBJECT_NAME.sql
(ex. scott@mydb.TABLE.EMP.sql, scott@mydb.TABLE.DEPT.sql)
You can see easily indexes that each table has.
You can see available other schema objects for connecting schema.
You can see available objects of connecting schema for other schema.
You can get DB information(V$NLS_PARAMETERS,V$OPTION etc.) by only click.
You can get ER diagrams automatically through FKs(Foreign KEY).

Figure 1.

The Figure 1. tells

The "EMPNO=8000" record is updated.(SAL:1200=>1250,COMM:10=>12)
The left-bottom corner tells "SCOTT.EMP" TABLE has 16 records.
The middle number "20msec" means the duration from the start time of SQL execution to the time of just before fetch.
The right number "6msec" means the duration of fetch.
"M_NPB_TEAM_LIST" table has 1 Bitmap Index/2 Function Index/1 PK/2 Unique Index.
"T_SOCCER_PLAYER_LIST" table has 1 PK/1 NONUNIQUE Index.
"UI_M_NPB_TEAM_LIST_NAME" index consists of "HEAD_NAME" column and "TAIL_NAME" column in "M_NPB_TEAM_LIST" table.

Figure 2.

The Figure 2. tells

Connecting schema can do "SELECT" to "EMP" table of "SCOTT" schema.
"SCOTT" schema can do "DELETE/INSERT/SELECT/UPDATE" to "T_NPB_PLAYER_LIST" table of connecting schema.
"T_NPB_PLAYER_LIST" TABLE reference "M_NPB_TEAM_LIST"/"M_NPB_POSITION" TABLE with FK(Foreign KEY),
while that table is referenced by "T_NPB_HIT_STATS"/"T_NPB_PITCH_STATS" TABLE.
"[T_NPB_PLAYER_LIST]-[TEAM_ID]" is a FK(Foreign KEY) for "[M_NPB_TEAM_LIST]-[ID]".
The Cost value is 6 for "select * from scott.emp e, scott.dept d where e.deptno = d.deptno".

Figure 3.

[Example:Excel=>DB(no disginated column)]

If you'd like to import a Excel file to a table defined by Figure 4 ,
you need to prepare a Excel data like Figure 5.
Figure 6. designates loading image.
Like Figure 6. ,if you set same column number and same order, you only have to write down data on a Excel file.
You can also use any SQL function and sub-queries for NUMBER/DATE type.

Figure 4.

SQL> desc t_soccer_player_list
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID					   NOT NULL NUMBER(10)
 ENG_NAME					    VARCHAR2(40)
 JPN_NAME					    VARCHAR2(40)
 NICK_NAME					    VARCHAR2(20)
 NATIONALITY					    VARCHAR2(20)
 BIRTHDAY					    NUMBER(8)
 REGIST_DATE					    DATE

Figure 5.

Figure 6.

[Example:Excel=>DB(designate column)]

If you designate column name on a Excel file like Figure 7., you don't need to worry about column number and order.
So, you can abbreviate any NULL permitted columns.
Figure 7.

Figure 8.

[Required Environment]

Qt4 library.
OCI library(Oracle).It is all right to install Oracle Client.Get the details from Oracle Site.
I only check this program on the following environment.

OS Fedora14(Linux)
Ubuntu 10.10(Linux)
Vista(Windows)

OCI Oracle11g Client
Oracle10g Client

[Preparation/How to install Qt4]

How to install Qt4 on Fedora

$ su root
# yum -y install qt4
# yum -y install qt4-devel

How to install Qt4 on Ubuntu

$ sudo su
# apt-get install libqt4-core libqt4-debug libqt4-debug-dev libqt4-dev libqt4-gui libqt4-qt3support libqt4-sql lsb-qt4 qt4-designer qt4-dev-tools qt4-doc qt4-qtconfig uim-qt

How to install Qt4 on Windows
1. Download "Qt SDK for Windows" from http://qt.nokia.com/downloads/
2. Execute the download file.
3. Add "C:\Qt\2010.05\qt\bin","C:\Qt\2010.05\mingw\libexec\gcc\mingw32\4.4.0" for the enviromental variable PATH.

[How to Compile on Linux]

Download tog_x.xx.tar.gz from http://sourceforge.net/projects/tinyoracleget/files/ at first.

I show you how to install to /usr/local/tog as an example.

$ gzip tog_x.xx.tar.gz | tar xvf -
$ cd tog_x.xx
$ ./configure --prefix=/usr/local/tog
$ make
$ su root
# make install

[How to install on Linux]

Download tog-x.xx-1.i686.rpm or tog-x.xx-1.i386.rpm from http://sourceforge.net/projects/tinyoracleget/files/.
Do the following steps.

$ su root
# rpm -ivh tog-x.xx-1.i686.rpm

This binary is compiled on 32bit PC.
And this is compiled with Oracle10g Client, but I confirm this works on Oracle11g Client.

[How to install on Windows]

An automatic compile doesn't work good on windows, so I attach only a 32bit binary.
I apologize my incovinence for 64bit PC Users.
This binary is compiled with Oracle10g Client, but I confirm this works on Oracle11g Client.

Download tog_x.xx.win.bin32.zip from http://sourceforge.net/projects/tinyoracleget/files/.
After decompress a download file, put the files on your favorite folder.

[How to Execute on Linux]

You need to set path to installed directory bin/lib and OCI library.
I show you how to set path /usr/local/tog as installed directory.

bash

export PATH=$PATH:/usr/local/tog/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/local/tog/lib

csh

setenv PATH $PATH:/usr/local/tog/bin
setenv LD_LIBRARY_PATH $LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/local/tog/lib

If you set path, you can execute this tool by this command.
$ tog

[How to Excute on Windows]

You need to set path to Qt4 and OCI library.
You only have to add path "C:\Qt\2010.05\qt\bin","$ORACLE_HOME/bin" by Control Panel.
I abbreviate how to use the Control Panel but show you one of the friendly site http://www.brightrev.com/how-to/windows/35-add-a-utilities-directory-to-your-pc.html?start=1.
After set path, you only have to double-click on "tog.exe".

[Tips]

The new version sqlplus seems to be unable to connect the old version Oracle DB.
I tested the below versions(Client<=>DB).

sqlplus(Client)	DB(Server)	Result
oracle10.2.0.1.0	oracle8.1.7.4.0	OK
oracle11.2.0.1.0	oracle8.1.7.4.0	NG
oracle10.2.0.1.0	oracle9.2.0.8.0	OK
oracle11.2.0.1.0	oracle9.2.0.8.0	OK
oracle10.2.0.1.0	oracle10.2.0.4.0	OK
oracle11.2.0.1.0	oracle10.2.0.4.0	OK
oracle10.2.0.1.0	oracle11.1.0.6.0	OK
oracle11.2.0.1.0	oracle11.1.0.6.0	OK

[Special Thanks]

This program uses the following 3 librarys.

Qt4 Library
http://qt.nokia.com/
Oracle OCI C++ Interface Library
Jordan Ritter - http://orapp.sourceforge.net/
C++ ExcelFormat Library
Martin Fuchs - http://www.codeproject.com/KB/office/ExcelFormat.aspx/

[Version History]

2011/05/20	ver1.18	Implement copy/find logic in SQL result spreadsheet.
2011/04/06	ver1.17	Implement insert/update/delete records on Table MDI Window.
2011/03/23	ver1.16	Implement absolute cursor position when search.
2011/03/12	ver1.15(M9.0 Higashi Nihon Huge Earthquake)	Implement Multi DB Connection
2011/03/03	ver1.14	Add Menu "Explain Plan"
2011/02/24	ver1.13	a part of items are changed from tab window to mdi window.
2011/02/17	ver1.12	fix garbled bug when saved to excel file.
		move a part of menus onto mdi window.
2011/02/09	ver1.11	Add Materialized View
		Change Excel Library
		Add rpm as a Linux binary.
2011/01/24	ver1.10	Available on Windows
2011/01/17	ver1.09	Switch Menu from "Useful SQL" to "Data Dictionary"
		Add Menu "Load Excel=>DB"
		Add Menu "Table/View/Trigger/Sequence/Type/Procedure/Function/Package List"
2011/01/06	ver1.08	Add Menu "Save PACKAGE DDLs"
		Add Menu "Save TRIGGER DDLs"
		Add Menu "Save SEQUENCE DDLs"
		Add Menu "Save TYPE DDLs"
2010/12/21	ver1.07	Add Menu "Useful SQL"
		Add "Automatically draw ER diagram"
2010/12/09	ver1.06	Add "Index List Each Table has."
		Add "Available Objects for Other Schema."
		Add "Available Other Schema Objects."
2010/12/02	ver1.05	Add Menu "Save INDEX DDLs"
2010/11/22	ver1.04	Add Menu "Save VIEW DDLs"
2010/11/15	ver1.03	Add Menu "Save TABLE DDLs"
2010/11/11	ver1.02	Add Menu "Save PROCEDURE DDLs"
2010/11/05	ver1.01

OS	Fedora14(Linux) Ubuntu 10.10(Linux) Vista(Windows)
OCI	Oracle11g Client Oracle10g Client