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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [PL/SQL] INSERT WITH ROWTYPE

RE: [PL/SQL] INSERT WITH ROWTYPE

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 8 Oct 2004 12:42:01 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF31@usahm018.exmi01.exch.eds.com>


With version 8.1 and lower you must reference every column by name in the insert statement value clause:
values (vrow.col1, vrow.col2, ....)

With version 9 you can insert a rowtype as a single statement as with "values rowtype". Notice no parenthesis around the rowtype variable.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jose Manuel Quesada Sent: Friday, October 08, 2004 7:58 AM
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 Received on Fri Oct 08 2004 - 11:45:45 CDT

Original text of this message

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