Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL - is inserting of %ROWTYPE variable possible?
On 7 Jan 2003 19:44:11 -0800, rs_arwar_at_hotmail.com (Rauf Sarwar)
wrote:
>Bogien <bogien_at_xcom.pl> wrote in message news:<3E1B57D3.DDBC8532_at_xcom.pl>...
Dont think so, but depending on what exactly you want to do, consider the following;
As you might know you can skip the first column-list (only when
inserting all columns), like this:
INSERT INTO tab VALUES (rec.a, rec.b, rec.c, rec.d, rec.e);
Also you could consider to directly insert from a select, thus
eliminating the need for a record-variable and some code to fill the
record, like this:
INSERT INTO tab SELECT a, b, c, d, e FROM ???
Hope this helps,
Hans van Dam. Received on Wed Jan 08 2003 - 09:52:14 CST