RE: [PL/SQL] INSERT WITH ROWTYPE
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <jmquesada@xxxxxxxxx>
- Date: Fri, 8 Oct 2004 16:22:48 +0200
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
Other related posts:
