Home » SQL & PL/SQL » Client Tools » SQL Plus 10g display settings
SQL Plus 10g display settings [message #445067] Thu, 25 February 2010 09:36 Go to next message
rosswelsh
Messages: 42
Registered: February 2010
Location: Sunderland
Member
Hi,

I am using SQL Plus 10g and when I execute a query my column widths are quite narrow, hence the titles and data are displayed as shown below. How can I change the settings so they are displayed side by side and the whole coulmn titles are visible?

TIMESTAMP
---------------------------------------------------------------------------
ACCOUNT_ CUSTOMER_ID BRANCH_ID TR AMOUNT ACCOUNT_BALANCE
-------- ----------- ---------- -- ---------- ---------------
23-NOV-09 13.45.14.000000
87654321 1002 1 WD 1700 -125




Thanks very much

[Updated on: Thu, 25 February 2010 09:37]

Report message to a moderator

Re: SQL Plus 10g display settings [message #445068 is a reply to message #445067] Thu, 25 February 2010 09:39 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
sqlplus format commands
Re: SQL Plus 10g display settings [message #445070 is a reply to message #445067] Thu, 25 February 2010 09:44 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*PlusĀ® User's Guide and Reference
Chapter 6 Formatting SQL*Plus Reports
Chapter 12 SQL*Plus Command Reference

Regards
Michel
Previous Topic: Data Export Tool
Next Topic: cant connect to isql plus
Goto Forum:
  


Current Time: Fri Dec 09 06:13:08 CST 2016

Total time taken to generate the page: 0.18883 seconds