Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Output Format Dilemma

Re: Output Format Dilemma

From: Sted Alana <Sted_Alana_at_hotmail.com>
Date: Thu, 02 May 2002 08:47:22 GMT
Message-ID: <3cd0fd31_1@news.iprimus.com.au>


Thankyou for your suggestion, but it does not fully solve my problem - see below

I can almost fit the whole table in by setting linesize to 250, but any higher does not make any improvements. It seems that telnet is limited to 250.

Please help.

SQL> select * from emp;

     EMPNO ENAME JOB MGRNO HIREDATE SAL COMM DEPTNO
---------- ---------- ---------- ---------- --------- ---------- ----------



      7839 alan trainer 17-NOV-93 5000     10
      7698 larry trainer 7839 01-MAY-95 3000     30
      7782 richard trainer 7839 09-JUN-97 4200     10
      7566 dean trainer 7839 02-APR-97 3200     40
      7654 mike salesman 7698 28-SEP-92 3300 3500     30
      7499 jim salesman 7698 20-SEP-93 1600 1000     30
      7844 jean salesman 7698 08-SEP-93 1500 0     30
      7900 james programmer 7698 03-DEC-95 3500 0     30
      7521 jill salesman 7698 22-FEB-95 2300 500     30
      7902 harry analyst 7566 03-DEC-97 3000     40
      7369 anne programmer 7902 17-DEC-96 1200     20
      7788 kim analyst 7566 09-DEC-96 3000     20
      7876 adam programmer 7788 12-JAN-98 3100     20
      7934 tim programmer 7782 23-JAN-98 4500     10 Received on Thu May 02 2002 - 03:47:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US