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

Home -> Community -> Usenet -> c.d.o.tools -> Re: LONG fields inside a trigger.

Re: LONG fields inside a trigger.

From: Morten Primdahl <morten_at_primdahl.net>
Date: Wed, 21 Mar 2001 22:56:41 +0100
Message-ID: <3AB92399.7D3EA586@primdahl.net>

Morten Primdahl wrote:
>
> Hi. Is it at all possible to do something like:
>
> CREATE TRIGGER ...
> INSERT INTO some_other_table (long_field)
> VALUES ('string A'||:new.this_long_field||'string B');

Use a PL/SQL table to contain intermedia result.

Yourself. Received on Wed Mar 21 2001 - 15:56:41 CST

Original text of this message

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