Attachment 1.2.1. Create table summary (File 1) in Oracle
/* source file: create.summary.sql*/
/* create summary file (File 1) of IBES data */
create table summary
( ticker varchar2(6) not null,
statpyy number(2) not null,
statpmm number(2) not null,
foreendy number(2),
foreendm number(2),
foreperi varchar2(5) not null,
numestis number(3) not null,
numup number(2),
numdown number(2),
estimed number(12,6) not null,
estimean number(12,6) not null,
estistdv number(12,6),
estihigh number(12,6) not null,
estilow number(12,6) not null
);
This page hosted by
Get your own Free Home Page