Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

why does sql*plus display all of the table names for each data field? 1

Status
Not open for further replies.
confission

confission

Programmer
Sep 28, 2002
10
0
0
US
hi. i'm using sql*plus, and when i do something like:

select * from customer; (or any other table)

the results are given back to me in a really-hard-to-read way. it displays all of the table names and only 1 field, for each field of data

can anyone help me to get it to display everything in a nice manner?

this is what i get when i select all from customer (and all of the following is just half of the data for one customer):


CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
50 Tower Street

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----


CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
Tampa

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
Florida

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
USA

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
32600

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
3539991343 1 1111111111111112

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
0108

CUSTID
----------
EMAIL
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
 
Sort by date Sort by votes


SET PAGES 99


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
Also look at SET LINESIZE 200 (or SET LINES 200). This widens the display so it won't wrap so much.

____________________________
Rich Tefft
PL/SQL Programmer
 
Upvote 0 Downvote
Is there a way to set this permanently? so you don't have to type SET LINES 200 everytime you start sql plus?



Use your resources, you're on the internet!
 
Upvote 0 Downvote
Include the statement(s) in .glogin or .login script


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
171
carp
carp
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
167
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
198
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
174
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
115
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top