OraFAQ Forum: Client Tools » sqlplus output formatting

Home » Other » Client Tools » sqlplus output formatting (Oracle 11.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus output formatting [message #648982]

Wed, 09 March 2016 07:50

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>

Report message to a moderator

Re: sqlplus output formatting [message #648985 is a reply to message #648982]

Wed, 09 March 2016 08:40

gazzag
Messages: 1119
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.

Report message to a moderator

Re: sqlplus output formatting [message #648988 is a reply to message #648982]

Wed, 09 March 2016 08:54

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> set pages 0 feed off
SQL> select sysdate from dual;
09/03/2016 15:54:00
SQL>

Report message to a moderator

Re: sqlplus output formatting [message #648989 is a reply to message #648988]

Wed, 09 March 2016 08:56

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Doh! I never thought of using FEED. Thanks!

Report message to a moderator

Re: sqlplus output formatting [message #648990 is a reply to message #648989]

Wed, 09 March 2016 09:11

gajini
Messages: 262
Registered: January 2006

Senior Member

Thanks Michel

Report message to a moderator

Previous Topic:	Someone please explain this behavior with multi-byte characters
Next Topic:	SQL Developer 3 - NLS settings not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 20:08:33 CST 2025