Oracle’s take on building visual queries

Being a big MySQL fan, I’m happy to report the open source database has been an awesome web development companion, especially when coupled with PHP or Perl.

This being said, the corporate world prefers DBAs with strong Oracle skills so if you’re looking to score some of the higher pay grade Oracle-centric jobs, perhaps you should take the Oracle SQL Developer software for a spin.

What you’ll find is a coherently organized set of work panes where you can see your databases’ entire (editable) content accompanied by a query construction zone where even relative database administration novices can work out perfectly coded SQL queries.

For those familiar with the rapid development alternatives, there are little differences between the visual query construction capable Oracle SQL Developer and the Oracle SQL*Plus software.

In fact, their feature lists are quite similar in the sense that both software let query database objects you have access to so you can add, alter and delete data by using data manipulation language (DML), work on database constructs using data definition language (DDL), write and run reports as well as create, edit and compile PL/SQL.

The range of GUI features for building and executing SQL queries visually is what makes Oracle SQL Developer a tool of choice for newbies, right up to experienced DBAs. In all fairness, every likes to work faster while generating generally flawless SQL query code.

You should also note that Oracle SQL Developer provides the SQL worksheet, a code editor window where you can enter and run statements that include SQL*Plus commandes, SQL and PL/SQL code — either single statements or multiple statements scripts.

So if you want to make a lot more money toying around with Oracle databases, probably as an Oracle DBA, your obvious choice is to use Oracle SQL Developer to manage common query tasks.

The easy-to-understand GUI tools will likely make you the new office hero!

Tags: oracle, sql, developer, queries, gui, dba, databases, dml, ddl, pl/sql