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