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
SQL could be implemented from DOS like this:
%RDBMS_HOME%\bin\%sqlplus% scott/tiger @%maindir%\sql\sqlstat.sql
This post has been archived. It cannot be replied.
Page address has been copied.
To share, click to copy page address.
Share Online by QR Code
Back To Topic:
Back To Forum: