Billy Ma
asked on
How to skip the extra text when using SPOOL in SQLPLUS
I written the following code, but the output is
SQL> select database from params;
MYDB
1 row selected.
SQL> spool off;
How to ONLY SPOOL THE RESULT WHICH is MYDB is my text file but not the other text?
Thanks!
SQL> select database from params;
MYDB
1 row selected.
SQL> spool off;
How to ONLY SPOOL THE RESULT WHICH is MYDB is my text file but not the other text?
Thanks!
set pages 0;
set heading off
set echo off;
spool c:\321.txt
select database from params;
spool off;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Are there any (Official) website explain these options?