Home » SQL & PL/SQL » 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: 261
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: 909
Registered: November 2010
Location: Bristol, 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: 65387
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: 909
Registered: November 2010
Location: Bristol, 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: 261
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 Feb 22 19:49:33 CST 2018

Total time taken to generate the page: 0.03828 seconds