Home » Other » Client Tools » sqlplus output formatting (Oracle 11.2.0.3.0)
sqlplus output formatting [message #648982] Wed, 09 March 2016 07:50 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
In sqlplus when executing a query with "head off" & "feedback off", there is an extra line before output.
I tried all the formatting options but nothing is worked out.
Please let me know how to remove that extra line occurs before the output.


SQL> select sysdate from dual;

09-MAR-16
SQL>


My expected result should be like this,

SQL> select sysdate from dual;
09-MAR-16
SQL>

Re: sqlplus output formatting [message #648985 is a reply to message #648982] Wed, 09 March 2016 08:40 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Not to my knowledge. I tend to process a spool file with sed if I need to reformat it.
Re: sqlplus output formatting [message #648988 is a reply to message #648982] Wed, 09 March 2016 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> set pages 0 feed off
SQL> select sysdate from dual;
09/03/2016 15:54:00
SQL>

Re: sqlplus output formatting [message #648989 is a reply to message #648988] Wed, 09 March 2016 08:56 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Doh! I never thought of using FEED. Thanks!
Re: sqlplus output formatting [message #648990 is a reply to message #648989] Wed, 09 March 2016 09:11 Go to previous message
gajini
Messages: 262
Registered: January 2006
Senior Member
Thanks Michel
Previous Topic: Someone please explain this behavior with multi-byte characters
Next Topic: SQL Developer 3 - NLS settings not working
Goto Forum:
  


Current Time: Thu Mar 28 13:16:18 CDT 2024