Copy this code and paste it in your HTML
src_schema
VARCHAR2(256) := 'EMPIK_DYNAMO_01'; target_schema
VARCHAR2(256) := 'EMPIK_PORTAL_BETA_1'; SELECT sequence_name
AS object_name
FROM all_sequences
WHERE sequence_owner
= src_schema
; EXECUTE IMMEDIATE 'CREATE or REPLACE SYNONYM ' || target_schema
|| '.' || next_row
.object_name
|| ' for ' || src_schema
|| '.' || next_row
.object_name
; DBMS_OUTPUT.put_line
('ERROR WHILE CREATING SYNONYM FOR: ' || next_row
.object_name
); /