dynamic 'INSERT' query?

How can we set A1, A2 values in dynamic 'INSERT’  query?

DECLARE

 _record        RECORD;

 _sql             VARCHAR(2000);

FOR _record IN SELECT A1, A2 FROM A

LOOP

_sql := 'INSERT INTO B VALUES (:A1, :A2)’;

EXECUTE (_sql);

END LOOP;

=================================================================

I can do this as (but I need another way instead of using || operator).

_sql := 'INSERT INTO B VALUES (‘ || _record.A1 || ’,’ || _record.A2 || ’)’;

=================================================================

Regards
Dinesh Pandey


----------------------------------------------------------------------------------
Dinesh Pandey 
Sr. Software Engineer