Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [PL/SQL] INSERT WITH ROWTYPE
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-lReceived on Fri Oct 08 2004 - 09:18:34 CDT
![]() |
![]() |