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: 19 Nov 2004 15:39:14 -0600
Message-ID: <u3bz5o6zk.fsf@standardandpoors.com>


On Fri, 19 Nov 2004, weberm_at_polaris.net wrote:
> 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).

Not true.

-- 
Galen Boyer
Received on Fri Nov 19 2004 - 15:39:14 CST

Original text of this message

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