[PL/SQL] INSERT WITH ROWTYPE

From: Jose Manuel Quesada <jmquesada_at_renta4.es>
Date: Fri, 8 Oct 2004 13:57:36 +0200
Message-ID: <072601c4ad2e$01fcc4a0$1b04a8c0@central>

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

Received on Fri Oct 08 2004 - 06:55:40 CDT