Pl/Sql and DBA Support.
This blog is created to provide support in Database and PL/Sql.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment