add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected

dbms_output:
v_sql=UPDATE PRJ1.Recipient set email = TRIM( ';' FROM email ||';'||? ) using ABC@yahoo.com
v_sql=UPDATE PRJ2.Recipient set email = TRIM( ';' FROM email ||';'||? ) using ABC@yahoo.com
v_sql=UPDATE PRJ3.Recipient set email = TRIM( ';' FROM email ||';'||? ) using ABC@yahoo.com
v_sql=UPDATE PRJ4.Recipient set email = TRIM( ';' FROM email ||';'||? ) using ABC@yahoo.com
v_sql=UPDATE PRJ1.Recipient set email = TRIM( ';' FROM email ||';'||? ) using xyz@yahoo.com
v_sql=UPDATE PRJ2.Recipient set email = TRIM( ';' FROM email ||';'||? ) using xyz@yahoo.com
v_sql=UPDATE PRJ3.Recipient set email = TRIM( ';' FROM email ||';'||? ) using xyz@yahoo.com
v_sql=UPDATE PRJ4.Recipient set email = TRIM( ';' FROM email ||';'||? ) using xyz@yahoo.com
v_sql=UPDATE PRJ1.Recipient set email = TRIM( ';' FROM email ||';'||? ) using 123@yahoo.com
v_sql=UPDATE PRJ2.Recipient set email = TRIM( ';' FROM email ||';'||? ) using 123@yahoo.com
v_sql=UPDATE PRJ3.Recipient set email = TRIM( ';' FROM email ||';'||? ) using 123@yahoo.com
v_sql=UPDATE PRJ4.Recipient set email = TRIM( ';' FROM email ||';'||? ) using 123@yahoo.com