about sqlldr load text reports
Hi
I have a problum on the text report load
now i have a text report like that
formosa sals pf report
seale manger:A1234 name:shark Lin
Dept Job Manager MgrNo Emp Name EmpNo Salary (Comm)
---- -------- -------- ----- -------- ----- --------- ------
20 Salesman Blake 7698 Shepard 8061 $1,600.00 (3%)
Falstaff 8066 $1,250.00 (5%)
Major 8064 $1,250.00 (14%)
30 Clerk Scott 7788 Conrad 8062 $1,100.00
Ford 7369
DeSilva 8063 $800.00
Manager King 7839 Provo 8065 $2,975.00
formosa sals pf report
seale manger:A1235 name:sara chen
Dept Job Manager MgrNo Emp Name EmpNo Salary (Comm)
---- -------- -------- ----- -------- ----- --------- ------
20 Salesman Blake 7698 Shepard 8061 $1,600.00 (3%)
Falstaff 8066 $1,250.00 (5%)
Major 8064 $1,250.00 (14%)
30 Clerk Scott 7788 Conrad 8062 $1,100.00
Ford 7369
DeSilva 8063 $800.00
Manager King 7839 Provo 8065 $2,975.00
if i need convert it to table
now i just have a idea let report insert line number like
00000001 formosa sals pf report
00000002 seale manger:A1234 name:shark Lin
00000003 Dept Job Manager MgrNo Emp Name EmpNo Salary (Comm)
00000004 ---- -------- -------- ----- -------- ----- --------- ------
00000005 20 Salesman Blake 7698 Shepard 8061 $1,600.00 (3%)
00000006 Falstaff 8066 $1,250.00 (5%)
00000007 Major 8064 $1,250.00 (14%)
00000008 30 Clerk Scott 7788 Conrad 8062 $1,100.00
00000009 Ford 7369
00000010 DeSilva 8063 $800.00
00000011 Manager King 7839 Provo 8065 $2,975.00
00000012
00000013 formosa sals pf report
00000014 seale manger:A1235 name:sara chen
00000015 Dept Job Manager MgrNo Emp Name EmpNo Salary (Comm)
00000016 ---- -------- -------- ----- -------- ----- --------- ------
00000017 20 Salesman Blake 7698 Shepard 8061 $1,600.00 (3%)
00000018 Falstaff 8066 $1,250.00 (5%)
00000019 Major 8064 $1,250.00 (14%)
00000020 30 Clerk Scott 7788 Conrad 8062 $1,100.00
00000021 Ford 7369
00000022 DeSilva 8063 $800.00
00000023 Manager King 7839 Provo 8065 $2,975.00
then
in file
load in
then
load record 002 and 0014 to take sale manger data
and load other to take sale data
but that can't not to process automaticly.
like may i can didn't to inert line number on file cane load text record no. into data base ?
does some can tell me how to do can load very smoothly.
regard.
Edited by: user3252842 on 2013/5/19 上午 5:21