SQL formatter in Oracle Raptor
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.
Related articles:
- Your SQL Tool Part II
- Better SQL Formatter in Oracle SQL Developer, Finally a Reality
- Oracle Bookmarklets, The Easiest Way to Search Documentation and More
Filed in Oracle on 28 Dec 05 | Tags: formatter, sql
I use pl/sql developer format sql
I must say I’m impressed so far. Now if they would only get EM 10gR2 released.
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 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.
Just noticed that I can no longer right-click the SQL worksheet area in Raptor R2 Build 08.97. CTRL-B still works, however.
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”.
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.
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.
Scott, instead of
GROUP BY (your_date_column)
use
GROUP BY TRUNC(your_date_column, ‘MM’)