spool emp_ename.txt SELECT ename FROM scott.emp; spool offWith the above commands in SQL*Plus, you will have a text file containing the output of just the ENAME column of the SCOTT.EMP table.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading