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