Home » Other » General » Tool for charting application data
Tool for charting application data [message #116875] Fri, 22 April 2005 11:53 Go to next message
OptionTrader
Messages: 20
Registered: January 2005
Location: Praha, Czech Republic
Junior Member
Can anybody recommend me a tool for simple charting of my application data from ORACLE database ?

I need simple dot or line charts mostly.
It is for my private use, not professional, only.

Is there any free or inexpensive tool to design charts from ORACLE data.

Thank for help.


Re: Tool for charting application data [message #117832 is a reply to message #116875] Fri, 29 April 2005 17:47 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Generate as csv output and load into Excel.

SQL> spool c:\t.csv
SQL> set pagesize 0
SQL> set linesize 80
SQL> set trimspool on
SQL> column object_name format a30
SQL> select object_id, object_name, created from user_objects where rownum < 5;
      6458,A                             ,22-FEB-05
      4175,ACCOUNT                       ,05-NOV-04
      4302,ACCOUNT1                      ,01-DEC-04
      4507,ACCOUNT10                     ,01-DEC-04

SQL> spool off
Re: Tool for charting application data [message #117929 is a reply to message #117832] Sun, 01 May 2005 14:30 Go to previous messageGo to next message
OptionTrader
Messages: 20
Registered: January 2005
Location: Praha, Czech Republic
Junior Member
Sorry, but this is too trivial solution.

My Selects are not static but time series for any selected Master variable
Re: Tool for charting application data [message #118015 is a reply to message #117929] Mon, 02 May 2005 10:57 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
1.) Run query directly from Excel
2.) HLMLDB
3.) Chart Builder http://www.oracle.com/technology/software/htdocs/distlic.html?/technology/software/tech/java/servlets/htdocs/utilsoft.htm
Re: Tool for charting application data [message #118614 is a reply to message #118015] Fri, 06 May 2005 08:12 Go to previous messageGo to next message
OptionTrader
Messages: 20
Registered: January 2005
Location: Praha, Czech Republic
Junior Member
Many thanks andrew again for your another help.
I was some time out so I am replying just now.

I don't know java programming so I think the Oracle Chart Builder isn't
right tool for me

Some questions :

I assume that charting in Excel means to use ODBC driver for accessing ORACLE data there.
Can you recommend me any information (white paper, WEB link on a y to use it etc) how to proceed.

What is HLMLDB your mentioned as a second alternative ?
Re: Tool for charting application data [message #118669 is a reply to message #118614] Fri, 06 May 2005 15:31 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
yes, Excel will use ODBC. I don't know of any guides - have you tried Excel help? It's pretty straight forward to run a query from Excel.

http://www.oracle.com/technology/products/database/htmldb/index.html
http://htmldb.oracle.com
Re: Tool for charting application data [message #118831 is a reply to message #118669] Mon, 09 May 2005 02:40 Go to previous message
OptionTrader
Messages: 20
Registered: January 2005
Location: Praha, Czech Republic
Junior Member
Thanks andrew again. That Excel use is maybe the right way to solve my demands
Previous Topic: DB Installation issues
Next Topic: Weird error installing Developer Suite
Goto Forum:
  


Current Time: Thu Apr 18 18:32:02 CDT 2024