Wednesday 13 March 2013

How to get data in file from Oracle using spool


SET TERMOUT OFF
SET LINES 108
SET PAGES 0


SELECT
ename            ,
empno            ,
SUBSTR(job,1,20),
hiredate      ,
salary
FROM
emp
WHERE ename='ALI'
AND   SALARY>5000
ORDER BY 2
.

SPOOL D:\EMPLOYEE_DATA.TXT
/
SPOOL OFF

No comments:

Post a Comment