Home » Other » 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: 13961
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sun Dec 22 06:18:56 CST 2024