sabato 16 maggio 2009

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;