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 09:04:39 GMT
Message-ID: <3cd10139_1@news.iprimus.com.au>


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 Received on Thu May 02 2002 - 04:04:39 CDT

Original text of this message

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