 | |
Visual Query tools for Oracle?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Visual Query tools for Oracle? -
03-19-2008
, 02:57 PM
|
In message 856b37d2-002a-4ed0-9985-708d8a069... (AT) q78g2000hsh (DOT) googlegroups.com>, vitalis... (AT) gmail (DOT) com writes I've just tried to draw a chart for "select object_type,count(*) from all_objects group by object_type having count(*)>500" with chart type "BAR_VERT_CLUST" but I just get a blank chart with the ojbect types at the bottom, the counts in a margin with associated colors, but no colored bars at all. Any idea? I'm ashamed but I have to admit that I haven't really read the f* manual. ;-) Well you could try reading the manual, but there isn't anything useful. SQLDeveloper charts are pretty but limited. For some reason you have to have three columns. Look at the object distribution report provided for an example. |
You're right, it works with "select object_type,object_type,count(*)
from
all_objects group by object_type,object_type having count(*)>500" !!
#22
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
SQL*PLus most of the time. :-)
Quote:
|
Any suggestions about existing tools are welcome, but please make sure that they are capable of working with large databases (hundred of tables and terabytes of data). |
terabyte reports, which I doubt any client tool will handle
gracefully).
Not 100% what you want but at least has support for table and column
name as well as keyword completion, which allows reasonable fast
creation of queries. No graphical output but support for several
databases among them oracle (with plan and other statistics display)
and it's cross platform.
http://squirrel-sql.sourceforge.net/
Kind regards
robert
#23
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
SQL*PLus most of the time. :-)
Quote:
|
Any suggestions about existing tools are welcome, but please make sure that they are capable of working with large databases (hundred of tables and terabytes of data). |
terabyte reports, which I doubt any client tool will handle
gracefully).
Not 100% what you want but at least has support for table and column
name as well as keyword completion, which allows reasonable fast
creation of queries. No graphical output but support for several
databases among them oracle (with plan and other statistics display)
and it's cross platform.
http://squirrel-sql.sourceforge.net/
Kind regards
robert
#24
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
SQL*PLus most of the time. :-)
Quote:
|
Any suggestions about existing tools are welcome, but please make sure that they are capable of working with large databases (hundred of tables and terabytes of data). |
terabyte reports, which I doubt any client tool will handle
gracefully).
Not 100% what you want but at least has support for table and column
name as well as keyword completion, which allows reasonable fast
creation of queries. No graphical output but support for several
databases among them oracle (with plan and other statistics display)
and it's cross platform.
http://squirrel-sql.sourceforge.net/
Kind regards
robert
#25
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
SQL*PLus most of the time. :-)
Quote:
|
Any suggestions about existing tools are welcome, but please make sure that they are capable of working with large databases (hundred of tables and terabytes of data). |
terabyte reports, which I doubt any client tool will handle
gracefully).
Not 100% what you want but at least has support for table and column
name as well as keyword completion, which allows reasonable fast
creation of queries. No graphical output but support for several
databases among them oracle (with plan and other statistics display)
and it's cross platform.
http://squirrel-sql.sourceforge.net/
Kind regards
robert
#26
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
I'll be glad to hear your opinion about our query building solution.
It exists as a separate freeware tool at http://www.activedbsoft.com/overview-querytool.html
and also it is available as a plug-in for PL/SQL Developer at
http://allroundautomations.com/plsqldevplugins.html (Active Query
Builder)
Sincerely
Sergey Smagin
#27
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
I'll be glad to hear your opinion about our query building solution.
It exists as a separate freeware tool at http://www.activedbsoft.com/overview-querytool.html
and also it is available as a plug-in for PL/SQL Developer at
http://allroundautomations.com/plsqldevplugins.html (Active Query
Builder)
Sincerely
Sergey Smagin
#28
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
I'll be glad to hear your opinion about our query building solution.
It exists as a separate freeware tool at http://www.activedbsoft.com/overview-querytool.html
and also it is available as a plug-in for PL/SQL Developer at
http://allroundautomations.com/plsqldevplugins.html (Active Query
Builder)
Sincerely
Sergey Smagin
#29
| |||
| |||
|
|
Is it possible that a good visual query tool for Oracle just doesn't exist? Don't tell me that real professionals don't use graphic tools, I have been designing database applications for 30 years but I still appreciate the speed of a good graphical interface. |
I'll be glad to hear your opinion about our query building solution.
It exists as a separate freeware tool at http://www.activedbsoft.com/overview-querytool.html
and also it is available as a plug-in for PL/SQL Developer at
http://allroundautomations.com/plsqldevplugins.html (Active Query
Builder)
Sincerely
Sergey Smagin
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.