For this task, the only available tools for me are SQL*Plus and Dos Shell. Now I'm testing the DOS solution. The point is that SQL*Plus doesn't support IF statement. And the same stuff also need to do with SQL*Server
-cyt(糖炒栗子);
2001-11-27{115}(#276951@0)
SQL could be implemented from DOS like this:
%RDBMS_HOME%\bin\%sqlplus% scott/tiger @%maindir%\sql\sqlstat.sql
I think the better way is to use the stored procedure. You have exception handling in PL/SQL which is important in loading data into the database.
-bluelamp(蓝灯);
2001-11-27(#277019@0)
Thanks for your prompt reply.
-cyt(糖炒栗子);
2001-11-27(#277277@0)