PL/SQL - is inserting of %ROWTYPE variable possible?

Hello,

Suppose I have a table named "tab" with columns "a", "b", "c", "d", "e". Now, I declare a variable named "rec" of type "tab%ROWTYPE", which reflects single record of the table.

Question:
Can I insert such variable into the table in PL/SQL at once?

So fat, I've been performing this task this way (doesn't look nice...): INSERT INTO tab (a, b, c, d, e) VALUES (rec.a, rec.b, rec.c, rec.d, rec.e);

Is something like "INSERT INTO tab VALUES rec" possible?

Thanks!

PS. I use Oracle 9i, if it can be of any help. Received on Tue Jan 07 2003 - 16:42:27 CST