How to show all columns in the output?

[gzq1]

Hi,

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?

I tried set linesize and set pagesize and no luck.

Thanks.

[hfx642]

I don't know how, if you are using SQLPlus (but I assume there is something similar).
However, if you are using SQLPlusW (the Windows version) look in the environment and increase your BUFFER size.