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
