OraFAQ Forum: Client Tools » a tools to display graph

Home » Other » Client Tools » a tools to display graph

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

a tools to display graph [message #268951]

Thu, 20 September 2007 03:30

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!

Report message to a moderator

Re: a tools to display graph [message #268953 is a reply to message #268951]

Thu, 20 September 2007 03:33

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

What front end client are you using?

Report message to a moderator

Re: a tools to display graph [message #269025 is a reply to message #268953]

Thu, 20 September 2007 08:38

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

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

So the users log into pl/sql developer to run the application ?

Report message to a moderator

Re: a tools to display graph [message #269029 is a reply to message #268951]

Thu, 20 September 2007 08:51

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How "select * from mytimeseries" can result to a graph?

Regards
Michel

Report message to a moderator

Re: a tools to display graph [message #269033 is a reply to message #268951]

Thu, 20 September 2007 08:57

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.

Report message to a moderator

Re: a tools to display graph [message #269036 is a reply to message #268951]

Thu, 20 September 2007 09:07

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

Report message to a moderator

Re: a tools to display graph [message #269041 is a reply to message #269029]

Thu, 20 September 2007 09:22

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...

Report message to a moderator

Re: a tools to display graph [message #269061 is a reply to message #269041]

Thu, 20 September 2007 10:51

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: a tools to display graph [message #269100 is a reply to message #269033]

Thu, 20 September 2007 12:46

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: a tools to display graph [message #269148 is a reply to message #269100]

Thu, 20 September 2007 17:09

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 09:00:05 CST 2025