Re: Output Format Dilemma

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Thu, 02 May 2002 12:57:09 -0500
Message-ID: <tvu2duop6lmbe27lfktm2ad5c5sd9p8s9p@4ax.com>

A few things to try:

set heading off                  /* This will eliminate the ugly top line */

column empno format 99999
column ename format a7
column job format a10
column mgrno format 99999
column hiredate format a7
column sal format 9999.99
column comm 9999.99
column deptno 99999

This should take around 70 chars to display....If space between is 1 col..  

"Sted Alana" <Sted_Alana_at_hotmail.com> wrote:

>It seems iam out by 3 spaces (ie 253 would work if it allowed it)
>
>The attributes are named correctly so I cant squeeze out more room.
>
>see below:
>
>empno = smallint
>ename = character(7)
>job = character(10)
>mgrno = smallint
>hiredate = date
>sal = numeric(4)
>comm = numeric(4)
>deptno = smallint
>
>select * from emp;
>
> EMPNO ENAME JOB MGRNO HIREDATE SAL COMM
>DEP
>TNO
>---------- ------- ---------- ---------- --------- ---------- ---------- ---
>----
>---
> 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
>

-----------== Posted via Newsfeeds.Com - Uncensored Usenet News ==----------

   http://www.newsfeeds.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Ulimited Fast Downloads - 19 Servers =----- Received on Thu May 02 2002 - 12:57:09 CDT