Home » SQL & PL/SQL » Client Tools » a tools to display graph
a tools to display graph [message #268951] Thu, 20 September 2007 03:30 Go to next message
aline
Messages: 92
Registered: February 2002
Member
Hi,


I'm looking for a tools to display timeseries stored in oracle database. Do you know if this kind or tools exists?
Ideally with this tools, a simple query like 'select * from mytimeseries' would display a graph.

thk for answer!


Re: a tools to display graph [message #268953 is a reply to message #268951] Thu, 20 September 2007 03:33 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What front end client are you using?
Re: a tools to display graph [message #269025 is a reply to message #268953] Thu, 20 September 2007 08:38 Go to previous messageGo to next message
aline
Messages: 92
Registered: February 2002
Member
we are using sqlplus and pl/sql developer

[Updated on: Thu, 20 September 2007 08:39]

Report message to a moderator

Re: a tools to display graph [message #269027 is a reply to message #268951] Thu, 20 September 2007 08:42 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
So the users log into pl/sql developer to run the application ?
Re: a tools to display graph [message #269029 is a reply to message #268951] Thu, 20 September 2007 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How "select * from mytimeseries" can result to a graph?

Regards
Michel
Re: a tools to display graph [message #269033 is a reply to message #268951] Thu, 20 September 2007 08:57 Go to previous messageGo to next message
aline
Messages: 92
Registered: February 2002
Member
yes,
they're job consist in analysis complex data. so plsql developer is the best tools to make complex ad hoc query.
Ideally, I'm searching a plug in to have a visual way to see data.
I have tried plot windows but unfortunately he didn't do the job.

Re: a tools to display graph [message #269036 is a reply to message #268951] Thu, 20 September 2007 09:07 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

Try the report option in PL/SQL Developer - From the File menu open a new report window, type in your query and let it execute, then on the far right hand side there is a graph option. Click on that and it will start the graph wizard.

You'll have to play with the options as I only found it by accident the other day (I was bored!!!).

HTH
Re: a tools to display graph [message #269041 is a reply to message #269029] Thu, 20 September 2007 09:22 Go to previous messageGo to next message
aline
Messages: 92
Registered: February 2002
Member
Michel Cadot wrote on Thu, 20 September 2007 08:51
How "select * from mytimeseries" can result to a graph?

Regards
Michel




Maybe the query could be more complex but it's the idea.
I have many registered data range by date and I would like to display them with date field in X-coordinate and other fields in Y-coordinate.
it do the job in an excel sheet!
So today, I'm importing data into excel and display it with the excel graph.
So if excel can do that...
Re: a tools to display graph [message #269061 is a reply to message #269041] Thu, 20 September 2007 10:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can write a program/macro in Excel VBA to directly generate your graph... if you know Visual Basic.

Regards
Michel
Re: a tools to display graph [message #269100 is a reply to message #269033] Thu, 20 September 2007 12:46 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
aline
... analysis complex data. so plsql developer is the best tools to make complex ad hoc query.

Did you consider to offer them Oracle Discoverer?
Re: a tools to display graph [message #269148 is a reply to message #269100] Thu, 20 September 2007 17:09 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You can also just use Apex...
http://download.oracle.com/docs/cd/B32472_01/doc/appdev.300/b32469/bar_chart.htm#CHDECIGH

or Sqlplus...
SQL> column Bar format a20
SQL> select rownum, lpad('>', rownum, '-') Bar
  2  from all_objects
  3  where rownum < 7;

    ROWNUM BAR
---------- --------------------
         1 >
         2 ->
         3 -->
         4 --->
         5 ---->
         6 ----->

6 rows selected.

SQL> 


even fancy stuff...
http://technology.amis.nl/blog/?p=398 (pie)
http://technology.amis.nl/blog/?p=1890 (Gantt)
http://technology.amis.nl/blog/?p=1965 (Hi-Low)
http://technology.amis.nl/blog/?p=1937 (Spedometer gauge)

[Updated on: Thu, 20 September 2007 17:09]

Report message to a moderator

Previous Topic: isql * plus not working
Next Topic: passing one parameter from Shell-script to Sql-script
Goto Forum:
  


Current Time: Wed Dec 07 16:49:16 CST 2016

Total time taken to generate the page: 0.14953 seconds