Re: [PL/SQL] INSERT WITH ROWTYPE
- From: Jose Manuel Quesada <jose.manuelquesada@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 8 Oct 2004 18:35:41 +0200
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx =
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jose Manuel
> >Quesada
> >Sent: 08 October 2004 13:58
> >To: oracle-l@xxxxxxxxxxxxx
> >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
> >
> >--
> >//www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
