Oracle Open Source : SQuirreL

Alex Nuijten 1
0 0
Read Time:1 Minute, 36 Second

Not too long ago my colleague Zeger Hendrikse gave this presentation on Open Source Databases. Part of this presentation are the Tools available.

One of the Tools he mentioned also has an Oracle Plugin available. So, continuing the story on Oracle and Open Source, may I present to you: SQuirreL

SQuirrel is developed in Java and is designed to connect to a multitude of databases, including Oracle. If you want or need to connect to some other database, it’s easy to download the appropriate plugin and connect to the database of choice.
This would add tremendous benefit, you don’t have to start learning a different kind of SQL tool each time you switch databases. The question remains, how often would you switch databases? (Especially since we’ve got Oracle ;-))

One of the things I like about SQuirrel is the fact that you can browse the database without leaving this tool. Tables, User Defined Types, Procedures are at your fingertips. Too bad it doesn’t distinguish between Packages, Procedures and Functions.
SQuirrel-Browser

In the SQL Editor, it’s possible to have multiple SQL statements. Depending on the position of the cursor, that statement is executed.
Results are shown in the tabs right under the SQL window. Unless you close the tabs, the results will remain there.
If you inadvertently create an invalid statement, the lower part of the window will turn red and show you the error it encountered.
SQuirrel-SQL Editor

I played with SQuirrel and an Oracle 10g Database and I like it a lot. There were some minor things which surprised me, but nothing to worry about.
Sometimes the feedback you get can be confusing. For instance if you delete rows from a table, you get a message like “15 Rows Updated.” If you Rollback or Commit, and not use the buttons to Rollback or Commit, it tells you “-1 Rows Updated”. A little odd, but no biggie.
All in All, it’s a great tool.

Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “Oracle Open Source : SQuirreL

Comments are closed.

Next Post

9.0.4.5 Maintenance Release Oracle Designer available

Today I discovered the 9.0.4.5 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 9.0.4.5 is not yet available on OTN’s Designer Software Page, there you will still find 9.0.4.4. If you have an existing Designer/SCM 10g […]
%d bloggers like this: