Member Avatar for 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.

  • 2 Contributors
  • 1 Reply
  • 88 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by hfx642
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.