Tool for charting application data [message #116875] |
Fri, 22 April 2005 11:53 |
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 |
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 #118614 is a reply to message #118015] |
Fri, 06 May 2005 08:12 |
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 ?
|
|
|
|
|