sqlplus command problems

Question

I am a newbie to sqlplus. I am trying to write a simple script to extract data to a file. First problem I am having: It describes the variables on the top of the output file, like

Old Value was
New Value is

I want this not be output if possible.

Secondly, i am trying to write the contents of a field to a file. The content of the field can vary, I have set the Linesize to 8000 but the return is around 50 characters or so. How do i get the full contents of the field?

Thank you in advance for your help.

Ollie · Accepted Answer · 2011-11-30 15:08:34Z

1

To prevent SQL*Plus showing the old and new variable values you need to set verify off:

SQL> SET VERIFY OFF

To pipe the output to a file you need the spool command:

SQL>SPOOL C:\myfile.txt
SQL>SELECT sysdate
  2 FROM dual;

SYSDATE
---------
30-NOV-11

SQL> SPOOL OFF

Hope it helps...

answered Nov 30, 2011 at 15:08

Ollie

17.6k8 gold badges50 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlplus command problems

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related