Oracle PL/SQL dual Table

Create update script of TABLEA based on fields of TABLEB.

Oracle PL/Sql Script :

set heading off
set pagesize 50000
set echo off
set trims on
set verify off
set feed off
set linesize 2000 

Spool &&FILE_NAME;


select '-- Dati creati il 'to_char(sysdate,'dd/mm/yyyy hh24:mi') from dual;
select '-- Inzio Scarico Tabella -- ' from dual;


select 'update TABLEA set FIELDA='  FIELDB  ' WHERE KEYA=''CHIAVE"; ' FROM TABLEB  &&WHERE_CLAUSEB. ;

select '-- Fine Scarico Tabella -- ' from dual;
　
select 'exit;' from dual;
Spool off;