Shell Programming and Scripting

updatestaging()
{
xx=`$ORACLE_HOME/bin/sqlplus -s $ORA_USER_PASS 2>/dev/null << EOF
     WHENEVER SQLERROR EXIT 1
     SET HEADING OFF SET FEEDBACK OFF SET VERIFY OFF SET PAGESIZE 0
       
     WHENEVER SQLERROR EXIT SQL.SQLCODE;
           
      update XX_IMPORT_DATA
      set file_id=< value from query)
      WHERE FILE_ID IS NULL;
      commit;
      exit
EOF`
}

update XX_IMPORT_DATA
      set file_id=( select max(id) from a )
      WHERE FILE_ID IS NULL;