Oracle Project Raptor, a new and free graphical tool that simplifies database development tasks such as browsing database objects, running SQL scripts, and editing PL/SQL statements, has just been released.
I quickly downloaded the 60.9 MB zip file and extracted it to c:\raptor. That was the installation part. As simple as extracting a zip file, cool. I then double clicked on c:\raptor\raptor.exe to run it.
I did not have time to play with every feature of this exciting new and free product, however, I did notice one feature: SQL formatting. What a coincidence! A few days ago, I blogged about a few SQL formatter tools. In Raptor, you can format your SQL by right clicking your mouse in the SQL Worksheet area and clicking on “Format SQL…”, or by simply hitting Ctrl-B
The SQL formatter also has a few preferences you can set by going to Tools/Preferences
I have tested it with somewhat simple SQL statements and it worked fine. I have yet to test it with more complex ones.
I believe this is just the beginning of a more mature and powerful tool.
Possibly related:
- Your SQL Tool Part II
- Better SQL Formatter in Oracle SQL Developer, Finally a Reality
- The Case of Better Readable Code
- YANC - Yet another name change
- Mini Blogs for 2007-04-07
Tagged formatter, sql | Post a Comment
Hope everything is working out...
I use pl/sql developer format sql
December 29th, 2005, at 12:27 am #I must say I’m impressed so far. Now if they would only get EM 10gR2 released.
December 29th, 2005, at 11:48 am #Hi,
this is a cool feature but not mature enough;
try to format PL/SQL with a named Parameter call :
param => Value
will be beautified to
param = > Value
and is not valid PL/SQL Code anymore.
But indeed a very interesting Tool
January 4th, 2006, at 11:35 pm #The Raptor!!
Karl
Carl, I agree with you, Raptor is not yet a mature product. By the time it is released to production, I’m sure it will be much better.
January 5th, 2006, at 12:43 pm #Just noticed that I can no longer right-click the SQL worksheet area in Raptor R2 Build 08.97. CTRL-B still works, however.
January 31st, 2006, at 7:17 am #They are releasing new builds so fast that I find it hard to track what’s changed or what’s not. I would wait for the production release before considering using it for “real”.
January 31st, 2006, at 7:35 am #As an FYI, R3 fixed the right-click issue.
I use it as a replacement for sqlplus on my desktop, since I can manage multiple databases at once. However, if I’m changing tablespaces or anything that might damage data, I fire up sqlplus.
January 31st, 2006, at 7:52 am #Eddie,
I have a question that will probably be pretty easy and straightforward for you. I have a date field that is in mm/dd/yyyy hh:mm:ss.
When I perform a query using the GROUP BY function within Raptor SQL*PLUS in Oracle, it groups by individual day. I want to tell the DB to ignore the day and only GROUP BY the month. Not sure how to do it.
August 18th, 2006, at 8:16 am #Scott, instead of
GROUP BY (your_date_column)
use
GROUP BY TRUNC(your_date_column, ‘MM’)
August 18th, 2006, at 10:07 am #