OraFAQ Forum: Server Administration » SQL Output redirection

Home » RDBMS Server » Server Administration » SQL Output redirection

Thu, 19 July 2001 00:54

Sandy R
Messages: 1
Registered: July 2001

Junior Member

How do you redirect the output generated by an SQL statement to a text file

Thu, 19 July 2001 01:35

Cindy
Messages: 88
Registered: November 1999

Member

SET VERIFY OFF
SET ECHO OFF

SPOOL filename.dat

SELECT *
FROM table_name
WHERE condition1
AND condition2;

SPOOL OFF
SET verify ON
SET ECHO ON

Previous Topic:	DATE TRUNCATING
Next Topic:	Re: Null-Value Problem

Goto Forum:

]

Current Time: Sat Jan 11 08:44:23 CST 2025