Idea for Very Cool 9i.x Feature

From: Post, Ethan <epost_at_kcc.com>
Date: Mon, 04 Jun 2001 10:22:27 -0700
Message-ID: <F001.0031A6E8.20010604095605@fatcity.com>

Where do we submit our ideas for enhancement ideas anyway?

I read an article by Dan Hotka about some of 9i's new features. One of them he calls "Data Pump". It allows you do define a SQL*Loader file structure internally using a CREATE statement. Then you can treat it just like any table or view. INSERT INTO table (SELECT * FROM blah) would actually pull the data in from the blah file on disk. Not sure if you can insert into the blah file but that would be very cool.

The next logical progression, and perhaps it already exists, would be to integrate this using XML and remote locations. For example you could do something like this:

CREATE VIEW remote_blah

   USING DTD '/u03/oradata/xml/salesorder.dtd'    FILE 'salesorder.xml'
   LOCATION 'ftp://www.customer.com/mydir'    USER blah
   PASSWORD cool;

Then to send a salesorder to the customers system you would just do an insert into remote_blah, the data would be transformed using the DTD or XSLT and sent via FTP or other possible protocols directly to the customers file systems. Most likely FTP would not be the best choice but you get the idea. The customer would define the incoming file as a view of some kind and just do a SELECT from it to take in your salesorder. In fact they could put a trigger on it that would automatically process the sales order. I'm sure this is coming and this would be very cool for all sorts of applications. It would in essence hook all of our systems together via our DB interface thus getting rid of another layer of abstraction.

Hope that all makes sense, let me know what you think! And no more COCO comments :) it's COCP - Ethan

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
INET: epost_at_kcc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 04 2001 - 12:22:27 CDT