@Echo off

CD C:\Report
echo Loadin tables from text file Report.txt
sqlplus security/password <c:\Report\loader_security.sql

echo Creating Security table
sqlplus security/password <c:\Report\creating_security_final.sql

echo Inserting text file Security table
sqlplus security/password <c:\Report\insert_security_final.sql

PAUSE

CD C:\Report\Security
echo Merging all Files
CALL merge.bat

CD C:\Report\Security
echo Deleting old files
CALL del.bat

CD C:\Report\Security
echo Executing SQL commands and loading file into SQL tables
CALL sql.bat

set ORACLE_SID=orcl
set ORACLE_HOME=C:\oracle\product\11.2.0\dbhome_1
set PATH=C:\oracle\product\11.2.0\dbhome_1\BIN


echo Delete Tables if any exist 
sqlplus security/password <c:\Report\clean_tables.sql

pause

  begin
    execute immediate 'drop table external_tables';
    execute immediate 'drop table security';
    exception
    when others then
    null;
  end;

drop table external_tables;
drop table security;

sqlplus security/password -s @c:\Report\clean_tables.sql

set echo off
set termout off
drop table external_tables;
drop table security;
exit;