I must say I'm impressed so far. Now if they would only get EM 10gR2 released.
Carl r.
· 3 years ago
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
Eddie Awad
· 3 years ago
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.
Tom_Fox
· 3 years ago
Just noticed that I can no longer right-click the SQL worksheet area in Raptor R2 Build 08.97. CTRL-B still works, however.
Eddie Awad
· 3 years ago
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".
Tom_Fox
· 3 years ago
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.
Scott Solomon
· 3 years ago
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.
All Comments
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')