Prashant Amburle

• Nov 4th, 2006

 

try below wiil resolve the problemspool c:a.txtselect tname||','||tabtype from tab;spool offopen a.txt

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

Spool the out put to text file as follows.

SET HEADING OFF;
SET FEEDBACK OFF;
SPOOL EXAMPLE.TXT
SELECT EMPNO || ','||ENAME||','||SAL FROM EMP;
SPOOL OFF;
SET FEEDBACK ON;
SET HEADING ON;