Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Q: How to create a virtual table/view?

Q: How to create a virtual table/view?

From: J. Wegener NOSPAM <xjw_at_xdde.xdk>
Date: Tue, 15 Jun 1999 13:33:34 +0200
Message-ID: <7k5dk1$m90$1@news101.telia.com>


Hi,

I want to be able to create a virtual table/view similar to that of the Oracle dynamic performance views. Does anybody know a way of doing so?

I am working on a system that utilizes a lot of hardware devices to measure such things as fluid temperatures and throughput. It is obviously possible to use the ORA_FFI package and access the output from the devices by calling a package or stored procedure, but having the output from the hardware devices presented as the rows and columns of a table or view strikes me as an elegant and convenient solution.

Any comment is valued, thanks in advance.

Cheers,
Johan
--
Johan Wegener
Dansk Data Elektronik A/S
Reply to: xjw_at_xdde.xdk
NOSPAM: Delete xxx from my email address Received on Tue Jun 15 1999 - 06:33:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US