Is Spreadsheet reporting possible?

Is Spreadsheet reporting possible?

Post by Ron L » Wed, 05 Oct 1994 04:42:03



Greetings,

I am designing an inventory system for my section.  This inventory
will maintain information about our workstations and the like.  I have
one main table to keep the information about each host.  Then I use
one table to keep track of commercial software packages on each host.  
Similiarly, I use another table to keep track of hardware configurations
and another table to keep track of point_of_contacts.  This was done
to accommodate for varying number of items in each category (i.e. table).
Is the right way of doing things?

What I want (my boss wants me ;^) to do is create a report similiar to
a spreadsheet.  Using some real and fictional data, this is an example
of what I basically need:

Host      Building   Room  Software      Hardware          POC's
                           Title         Item
----------------------------------------------------------------
grizzly    97        166A  WordPerfect   Monitor-mono      Ed
                           AutoCad       Disk1-100M        Marion
                           WingZ         Disk2-200M
                           SunProC
                           Ada

iguana     97         160  Oracle7       Monitor-Color     Dave
                                         Disk1-200M        Ed
                                                           Ron
                                                           Ken

I am using ORACLE7  with SQL*Plus (3.1),  PL/SQL (2.0), and SQL*Forms
(3.0).  Do I have the right products to pull this off?  Did I design
this inventory system correctly?  Or did I do a major goof on the concepts
of database theory?

---

If I can't, is there any way I can query the data into comma/semi-colon
delimited form?  This way I can program my way thru this in C or Perl or
pump it into a spreadsheet:

grizzly;97;166A;WordPerfect,Autocad,WingZ,SunProC,Ada;Monitor-mono, etc.

----

My background:
I've had some short courses on Database Concepts and SQL, read "Database
Systems Concepts" by Korth and Silberschantz.  I've looked in
Mastering Oracle7 and Client/Server Computing, Oracle7 manuals and the
FAQ.   Thus, you can say I'm new to this world of RDBMS.

Thanks very, very much for any info,
--Ron
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   Ron Lee of CCS Operational Networks  | Naval Research Lab (Code 5592)

   Phone:  202-767-3903                 | Washington DC 20375

INTERNET QUOTE:
"Thru the gateway, off the repeater, over the T-3 backbone, nothing but 'Net"
                                                 - Michael G. Reed
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

 
 
 

1. How am supposed to know which init file I am using pfile or spfile?

Hi guys,

I have a strange question here,
How am I going to find out which init file my instance is using?
Since I always start my instance by issue "startup" without any
parameter, I am really sure which init file I am actually using.

It may appears stupid and unnecessary, but I need know that.Thanks!

--

2. Global Catalog

3. Is it possible to Start Oracle Report Server during Unix Bootup ?

4. Virtual server account mixup

5. Info on spreadsheet access to databases

6. Re-using Sun Ray 150 monitor?

7. Unix spreadsheet in SpecInt92

8. Help-AutoCad LT-Showing objects you are moving

9. USER EXIT FOR Wingz (or other spreadsheet options)

10. Ole and Excel spreadsheet

11. SpreadSheet >>> Oracle DB ??

12. Spreadsheet load into Oracle7 RDBMS

13. Looking for Lotus or Excel spreadsheet for Sizing and Capacity Planning Whitepaper