How to show all of my columns in the output in SQL PLUS - Oracle 10g?
906899Dec 21 2011 — edited Dec 22 2011Hi, I have googled my question and FAQ in this forum but couldn't find the answer. The version of my Oracle is 10204.
I am using SQL Plus Oracle 10g and sometimes when I ran a query such as:
select * from employees;
some of the columns were cut off in the results because the table contains too many columns.
So my question is: how can I let all columns be displayed in the result?
For example:
--------------------------------------------------------------------------------
Create table Employees(
EmployeeID Number(3) primary key,
FirstName VARCHAR2(15),
MiddleName VARCHAR2(3),
LastName VARCHAR2(15),
Title CHAR(30),
WorkPhone CHAR(15),
Salary Number(7,2),
YearsInService Number(2),
DepartmentID Number(3),
Manager Number(3),
Cook Number(3),
Chef Number(3),
Officer Number(3),
Chief Number(3),
Boss Number(3),
CEO Number(3)
);
But when I ran select * from employ; only columns till MANAGE are displayed
EMPLOYEEIDFIRSTNAME MIDLASTNAME TITLE WORKPHONE SALARYYEARSINSERVICEDEPARTMENTID MANAGE
--------------------------------------------------------------------------------
What I want is to have all columns showed up in the result without being cut off.
I tried set linesize and set pagesize and no luck.
Thanks.