pl/sql inserting a record at a time
From: <news_browser_at_my-deja.com>
Date: Tue, 30 Nov 1999 18:51:10 GMT
Message-ID: <8216as$rma$1_at_nnrp1.deja.com>
Hello,
I was wondering if I could insert a complete record in PL/SQL without giving out each field. Please see below:
Date: Tue, 30 Nov 1999 18:51:10 GMT
Message-ID: <8216as$rma$1_at_nnrp1.deja.com>
Hello,
I was wondering if I could insert a complete record in PL/SQL without giving out each field. Please see below:
Declare
v_my_row abc_row%TYPE;
// ...
BEGIN
v_my_row.a := 1; v_my_row.b := 'a';
- //etc...
insert v_my_row into abc_row; --> //THIS DOES NOT WORK
- //and I don't want to say
- insert into abc_row values (
- v_my_row.a,
- v_my_row.b )
- //IS THERE ANY OTHER WAY OF DOING IT?
Thanksalot.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 30 1999 - 19:51:10 CET