Oracle has released a new graphical tool called "Project
Raptor". It's like Oracle's Enterpise Manager, but it is geared more towards
an application developer than a DBA. WIth this tool you can create objects,
select and modify data, and much more. Best of all, it's free!
First, let's look at the navigation. Just about any
object type that a developer would deal with is listed here.  By
default, the objects shown below these folders are the ones owned by the user
you are logged in as. To see objects owned by other users, you can click the
"Other Users" section at the bottom to see their objects.
All of the source types, like triggers, functions,
etc. are available at the top level unlike Oracle's Enterprise Manager where
they are grouped together at a lower level in the navigation tree. Also, if
you are using Oracle 10g Database and flashback technology, you can see dropped
objects that are in the "Recycled Bin". This makes it easy to bring
your deleted objects back to life.
From Raptor, you can easily RENAME, COPY, DROP, TRUNCATE, LOCK, and ADD COMMENTS
to you tables.
If you right-click any table you can export the table and its data in various
formats including: XML, CSV, INSERT Statements, SQL Loader, and DML.
I like that finally Oracle provides a free utility
that allows developers to work with SQL, Stored Procedures, Triggers, Functions,
etc. with an easy to use tool that supports a lot of functionality.
This isn't a full production version and is still
a little buggy. Also, I don't like that if I want to execute multiple SQL Statements
at the same time I can only get a text based output where as with a single SQL
statement I can get a tabular format.
Here are a couple screenshots from Project Raptor.
Click the picture for a larger image.
 |
Running a single SQL statement and having
the data return in tabular format. |
 |
Running multiple SQL statements and having the data
return in text based output. |
 |
A look at a table definition. |
~ Troy Campano
~
|
