Attachment 1.2.3.  Load table summary (File 1) in Oracle

load data
infile *
into table summary
fields terminated by ',' 
(
ticker, 
statpyy, 
statpmm,
foreendy,
foreendm,
foreperi,
numestis,
numup,
numdown,
estimed,
estimean,
estistdv,
estihigh,
estilow
)
begindata
A ,83 ,10 ,83 ,12 ,FY 1 ,1 ,0 ,0 ,0.2 ,0.2 ,. ,0.2 ,0.2
A ,83 ,10 ,84 ,12 ,FY 2 ,1 ,0 ,0 ,2.47 ,2.47 ,. ,2.47 ,2.47
A ,83 ,11 ,83 ,12 ,FY 1 ,1 ,0 ,0 ,0.2 ,0.2 ,. ,0.2 ,0.2
A ,83 ,11 ,84 ,12 ,FY 2 ,1 ,0 ,0 ,2.47 ,2.47 ,. ,2.47 ,2.47
A ,83 ,12 ,83 ,12 ,FY 1 ,1 ,0 ,0 ,0.2 ,0.2 ,. ,0.2 ,0.2
A ,83 ,12 ,84 ,12 ,FY 2 ,1 ,0 ,0 ,2.47 ,2.47 ,. ,2.47 ,2.47
A ,86 ,1 ,. ,. ,LTG ,1 ,0 ,0 ,15 ,15 ,. ,15 ,15
A ,86 ,1 ,85 ,12 ,FY 1 ,1 ,0 ,0 ,0.01 ,0.01 ,. ,0.01 ,0.01
A ,86 ,1 ,86 ,12 ,FY 2 ,1 ,0 ,0 ,1.75 ,1.75 ,. ,1.75 ,1.75
A ,86 ,2 ,. ,. ,LTG ,1 ,0 ,0 ,15 ,15 ,. ,15 ,15
A ,86 ,2 ,85 ,12 ,FY 1 ,1 ,0 ,0 ,0.01 ,0.01 ,. ,0.01 ,0.01
A ,86 ,2 ,86 ,12 ,FY 2 ,1 ,0 ,0 ,1.75 ,1.75 ,. ,1.75 ,1.75
A ,86 ,3 ,. ,. ,LTG ,1 ,0 ,0 ,15 ,15 ,. ,15 ,15
A ,86 ,3 ,85 ,12 ,FY 1 ,1 ,0 ,0 ,0.01 ,0.01 ,. ,0.01 ,0.01
A ,86 ,3 ,86 ,12 ,FY 2 ,1 ,0 ,0 ,1.75 ,1.75 ,. ,1.75 ,1.75
………………

This page hosted by Get your own Free Home Page