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: Galen Boyer <galenboyer_at_hotpop.com>
Date: 18 Nov 2004 12:03:08 -0600
Message-ID: <uzn1ft4u1.fsf@standardandpoors.com>


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.

-- 
Galen Boyer
Received on Thu Nov 18 2004 - 12:03:08 CST

Original text of this message

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