confission
Programmer
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
----
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
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
50 Tower Street
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
Tampa
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
Florida
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
USA
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
32600
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
3539991343 1 1111111111111112
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----
0108
CUSTID
----------
--------------------------------------------------------------------------------
PASSWORD FNAME
-------------------- --------------------------------------------------
LNAME
--------------------------------------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
CITY
--------------------------------------------------
STATE
--------------------------------------------------
COUNTRY
--------------------------------------------------
POSTALCODE
--------------------------------------------------
PHONENO CARDTYPE CARDNUMBER
-------------------------------------------------- ---------- ----------------
EXPD
----