Blog

Category Filtering: 'Oracle'

Remove Filter


Oracle's SQL Developer, Better than Toad

Posted by Luis Majano
Mar 21, 2006 00:00:00 UTC
Finally Oracle came up with their own graphical tool for creating and browsing database objects. This is the perfect companion to Oracle XE. The look and feel is great and the responsiveness of the application is amazing. It has all the tools that I need as an Oracle developer to finally develop on any platform. Yep, totally JAVA!!! This is amazing!! The tool has SQL worksheets, SQL formatting, PL/SQL snippets, a great help system, a great PL/SQL editor, which will keep beign improved on. Overall, the application is great, and best of all, I can finally run this on my Mac and get rid of my DB PC. Ohh, and did I mention that it is also free!! Thank you Oracle!!

Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.

SQL Developer can connect to any Oracle Database version 9.2.0.1 and later. We support SQL Developer running on Windows, Linux and Mac OSX.

Link:

http://www.oracle.com/technology/products/database/sql_developer/index.html

Anyways, here are some good screenshots for you:

Oracle XE production release Mini Review

Posted by Luis Majano
Feb 28, 2006 00:00:00 UTC
I just recently installed beta 3 of Oracle Express and was amazed with it. I have been doing Oracle development alongside ColdFusion for about 6 years now. Oracle is not an easy puppy to install and configure, especially under Linux or any Unix flavor. However, in windows, although performance lacking, but installation heaven.

Oracle release the production version of XE on Feb 24 and I should be trying to upgrade to it this week.

Screenshots

Administration Home


Object Browser Home

As for the beta 3 here is my mini-review:

With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations.

Oracle Database XE can be installed on any size host machine with any number of CPUs, but this free version of the world's leading database will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

The installer is pretty straightforward and easy to setup. The only weird thing I experienced was that I was unable to connect to other databases I had setup on my 10g Client install. Since XE replaces the system paths, everything looks at this new Oracle Home. So I basically had to move all my entries on my tnsnames.ora to the one in the XE directory. Simple and logical.

Apart from that little glitch, the database purrs!! I was connected to it through Toad, Coldfusion, DB Solo, and Aqua Data Studio with no problems. The database web tool is extremely intuiative and easy to use.

This database is a great starter database if you haven't messed in the Oracle World. Every feature is there as far as I can see, except well the 4gb of data limitation.

Here is a great blog by Tug, who has created a viewlet that shows you how easy it is to install this wonderful database.

 


Site Updates

Archives

Entries Search