SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLPLUS : How to generate a txt file supressing the command

791045Oct 21 2010 — edited Oct 21 2010

I'm generating a text file using these commands in sqlplus :

Column chave_acesso format a46
Column dt_alt format a10
set pagesize 100
spool arquivo.txt
select chave_acesso, dt_alt from tab

Everything is perfect, except for 1 little detail.
The command "select chave_acesso, dt_alt from tab" appears in the txt file...
Is there a way of eliminating it ?

Eduardo

This post has been answered by Frank Kulash on Oct 21 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2010

Added on Oct 21 2010

6 comments

592 views