%ROWTYPE Insert

[qnrt]

Hi...

I've 2 tables lang & lang_desc. lang_desc has an additional description field. Can I insert into lang_desc table a row selecting it from lang table using %ROWTYPE without implicitly assign the fields? The below code works but it is assigning the fields...
************************************************** *********************
CREATE TABLE LANG
(
ID VARCHAR2(9),
LANGUAGE_CODE VARCHAR2(5)
);


CREATE TABLE LANG_DESC
(
ID VARCHAR2(9),
LANGUAGE_CODE VARCHAR2(5),
DESCRIPTION VARCHAR2(30)
);
************************************************** *****************

DECLARE
r_lang lang%ROWTYPE;
r_lang_desc lang_desc%ROWTYPE;


BEGIN

SELECT * INTO r_lang FROM lang where iD = '15649';

r_lang_desc.id := r_lang.id;
r_lang_desc.language_code := r_lang.language_code;

INSERT INTO lang_desc
VALUES r_lang_desc;
COMMIT;

END;

[Saii]

You can use insert with select syntax. Will that fulfill your requirement?

[qnrt]

INSERT INTO lang_desc (id, language_code)
(SELECT * FROM lang where iD = '15649') ;
COMMIT;

Yeah this will work.. But my actual scenario is 2 tables with more than 40 fields.. Any other solutions??