本帖最后由 〇〇 于 2011-10-19 14:13 编辑
col c1 for 999999
col c2 for a20
col c3 for a8
col c4 for 999999999999999
col c4 for a30
select lpad(rownum,6,0) c1, rpad(b.bank_c_num,20,' ') c2, to_char(a.s_date,'yyyymmdd') c3, lpad(a.loan - a.debit, 15, ' ') c4 , lpad(' ',30, ' ') c5
from tab1 a, tab2 b
where a.c_num = b.c_num
and rownum < 10;
C1 C2
C3 C4
C5
------------ -------------------- -------- ------------------------------ ------------------------------
000001 5184751100055206 20090630 176.9
000002 5184751100055206 20091115
198
000003 5184751100055206 20091115
39.6
#而我想要的是下面的格式:
1C2
C3 C4
C5
------ -------------------- -------- --------------- ------------------------------
000001 5184751100055206 20090630 176.9
000002 5184751100055206 20091115
198
000003 5184751100055206 20091115
39.6
|