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(糖炒栗子)
SQL could be implemented from DOS like this:
%RDBMS_HOME%\bin\%sqlplus% scott/tiger @%maindir%\sql\sqlstat.sql
(#276951@0) Last Updated: 2001-11-27 This post has been archived. It cannot be replied.