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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to add an object to an existing table?

Re: How to add an object to an existing table?

From: Ubiquitous <weberm_at_polaris.net>
Date: Fri, 19 Nov 2004 03:06:25 +0000 (UTC)
Message-ID: <cnjnvh$l3o$15@news.utelfla.com>


Galen Boyer <galenboyer_at_hotpop.com> wrote:
: On Thu, 18 Nov 2004, weberm_at_polaris.net wrote:
:> DA Morgan <damorgan_at_x.washington.edu> wrote:

:>: A trigger. A trigger can call any package, procedure, or
:>: function.
:>
:> Ah, but how would you trigger the trigger to parse and load the
:> data file?
:
: Use an external table to "parse" the file and a select against
: that external table to "load" the file and a trigger to kick the
: whole thing off.

I see, but that's a LOT more work just invoking load_table(file_name).   Received on Thu Nov 18 2004 - 21:06:25 CST

Original text of this message

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