Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Output Format Dilemma
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