Re: [PL/SQL] INSERT WITH ROWTYPE

OK, Chris. Thanks for the answer. I'll wait until migration then :(

By the way, I have a similar question.

Is there any way to tell a BEFORE UPDATE trigger that it only has to be executed if at least one column has been modified witout saying WHEN OLD.COL1 <> NEW.COL1 OR
OLD.COL2 <> NEW.COL2 OR
...
OLD.COLn <> NEW.COLn

Thanks again

On Fri, 8 Oct 2004 16:22:48 +0200, Christian Antognini <christian.antognini_at_trivadis.com> wrote:
> Hi=20
>
> This is a 9.2 feature.=20
> The correct syntax is: INSERT INTO MYTABLE VALUES vRow;
>
> Chris
>
>
>
> >-----Original Message-----
> >From: oracle-l-bounce_at_freelists.org =
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jose Manuel
> >Quesada
> >Sent: 08 October 2004 13:58
> >To: oracle-l_at_freelists.org
> >Subject: [PL/SQL] INSERT WITH ROWTYPE
> >
> >Hi all.
> >Environment: Oracle 8.1.7.4
> >
> >Suppose I have a table MYTABLE with 40 columns.
> >
> >Is there a way to code in PL/SQL an INSERT statement using a ROWTYPE =
> variable.
> >
> >Something like this:
> >---------------------------------------------------
> >---------------------------------------------------
> >DECLARE
> > vRow MYTABLE%ROWTYPE;
> >BEGIN
> > ...
> > ...
> > ...
> > INSERT INTO MYTABLE vRow;
> >END;
> >---------------------------------------------------
> >---------------------------------------------------
> >
> >Thanks
> >
> >--
> >http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l