Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 24th 04, 11:43 AM posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.fr.excel
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 2
Default Graphic Visualization of an ORACLE data on EXCEL

Hi Everone,

I am a new on EXCEL.
I am using an Excel to display the data from an Oracle database.
I am using several excel sheets in order to display various data from
an Oracle database.
For example: sheet one for displaying the oracle users information,
sheet two for displaying oracle files information etc.

I am using the following query for displaying the data in one of an
excel sheet:

QUERY:

select username, ''''||sid||','||serial#||''''
sid_serial,status,module, OSUSER "Workstations",MACHINE
Hostname,PROGRAM,
to_char(logon_time,'DD/MM/YYYY HH24:MI:SS') "Logon Time"
from v$session where username is not null and status ='ACTIVE'
/


Following are the data of the above query, which is dsplayed on one
of an EXCEL Sheet:

USERNAME SID_SERAIL STATUS DATABASE

TOM 656.989 ACTIVE TEST
THOMAS 123.989 ACTIVE TEST
.. . ..


Now I wanted that the above data, only the Uername,Status,Database
columns would be displayed as a GRAPHIC-VISUALIZATION.

I wanted that Database Name and the Username and below the USERNAME
their Status will be shown on an EXCEL CHART.

I tried to make a chart on EXCEL but it did not get the complete
information as I wanted.

ON EXCEL SHEET, first I highlited the Colum "USERNAME" and at a
sametime the column "status" with all the rows,but didn't get the
desired result on an excel chart.
Could someone please give me the suggestion/solution that how to
disply the desired information on EXCEL CHART.?

I will appreciate if someone inform me about it.

Thanks

Regards

BILAL

  #2   Report Post  
Old February 24th 04, 01:52 PM posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.fr.excel
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Graphic Visualization of an ORACLE data on EXCEL

Charts are for displaying numeric quantities or perhaps percentages on a pie
chart. Do you mean a table? Perhaps you should select your data and do
Data=Pivot Table Reports and charts. Then walk through the wizard. In the
last dialog, use the layout button to layout the table you want to see.
There are also pivottable charts which can be tied to the pivot table. See
help for details.

--
Regards,
Tom Ogilvy

"MATHEW KING" wrote in message
om...
Hi Everone,

I am a new on EXCEL.
I am using an Excel to display the data from an Oracle database.
I am using several excel sheets in order to display various data from
an Oracle database.
For example: sheet one for displaying the oracle users information,
sheet two for displaying oracle files information etc.

I am using the following query for displaying the data in one of an
excel sheet:

QUERY:

select username, ''''||sid||','||serial#||''''
sid_serial,status,module, OSUSER "Workstations",MACHINE
Hostname,PROGRAM,
to_char(logon_time,'DD/MM/YYYY HH24:MI:SS') "Logon Time"
from v$session where username is not null and status ='ACTIVE'
/


Following are the data of the above query, which is dsplayed on one
of an EXCEL Sheet:

USERNAME SID_SERAIL STATUS DATABASE

TOM 656.989 ACTIVE TEST
THOMAS 123.989 ACTIVE TEST
.... ...... ..... .....


Now I wanted that the above data, only the Uername,Status,Database
columns would be displayed as a GRAPHIC-VISUALIZATION.

I wanted that Database Name and the Username and below the USERNAME
their Status will be shown on an EXCEL CHART.

I tried to make a chart on EXCEL but it did not get the complete
information as I wanted.

ON EXCEL SHEET, first I highlited the Colum "USERNAME" and at a
sametime the column "status" with all the rows,but didn't get the
desired result on an excel chart.
Could someone please give me the suggestion/solution that how to
disply the desired information on EXCEL CHART.?

I will appreciate if someone inform me about it.

Thanks

Regards

BILAL



  #3   Report Post  
Old February 25th 04, 07:29 AM posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.fr.excel
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 2
Default Graphic Visualization of an ORACLE data on EXCEL

Hi TOM,

Thanks for your info.
I am using a table.I am not using numeric data for making charts.

Thanks
Bilal

"Tom Ogilvy" wrote in message ...
Charts are for displaying numeric quantities or perhaps percentages on a pie
chart. Do you mean a table? Perhaps you should select your data and do
Data=Pivot Table Reports and charts. Then walk through the wizard. In the
last dialog, use the layout button to layout the table you want to see.
There are also pivottable charts which can be tied to the pivot table. See
help for details.

--
Regards,
Tom Ogilvy

"MATHEW KING" wrote in message
om...
Hi Everone,

I am a new on EXCEL.
I am using an Excel to display the data from an Oracle database.
I am using several excel sheets in order to display various data from
an Oracle database.
For example: sheet one for displaying the oracle users information,
sheet two for displaying oracle files information etc.

I am using the following query for displaying the data in one of an
excel sheet:

QUERY:

select username, ''''||sid||','||serial#||''''
sid_serial,status,module, OSUSER "Workstations",MACHINE
Hostname,PROGRAM,
to_char(logon_time,'DD/MM/YYYY HH24:MI:SS') "Logon Time"
from v$session where username is not null and status ='ACTIVE'
/


Following are the data of the above query, which is dsplayed on one
of an EXCEL Sheet:

USERNAME SID_SERAIL STATUS DATABASE

TOM 656.989 ACTIVE TEST
THOMAS 123.989 ACTIVE TEST
.... ...... ..... .....


Now I wanted that the above data, only the Uername,Status,Database
columns would be displayed as a GRAPHIC-VISUALIZATION.

I wanted that Database Name and the Username and below the USERNAME
their Status will be shown on an EXCEL CHART.

I tried to make a chart on EXCEL but it did not get the complete
information as I wanted.

ON EXCEL SHEET, first I highlited the Colum "USERNAME" and at a
sametime the column "status" with all the rows,but didn't get the
desired result on an excel chart.
Could someone please give me the suggestion/solution that how to
disply the desired information on EXCEL CHART.?

I will appreciate if someone inform me about it.

Thanks

Regards

BILAL



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel data upload to Oracle Brent Excel Discussion (Misc queries) 0 March 8th 07 08:01 PM
Excel data upload to Oracle Jim Thomlinson Excel Discussion (Misc queries) 0 March 8th 07 07:39 PM
How to get data from Oracle Database to Excel? David Willis New Users to Excel 1 March 31st 06 01:57 PM
data visualization utefan001 Charts and Charting in Excel 1 June 1st 05 04:35 PM
Oracle data to excel Kim[_8_] Excel Programming 2 October 21st 03 12:29 PM


All times are GMT +1. The time now is 05:30 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017