Wednesday 13 March 2013

DBMS Spool file Creation Steps

how to create a spool file?

steps:


spool off;
spool e:/insert3.sql;
REM WHICH FILE U WANT TO WRITE
set echo on;
@e:/insert2.sql;
REM WHICH FILE U WANT TO READ

No comments:

Post a Comment