Attachment 1.2.2.  Create table sig (File 5) in Oracle

/* create sig (or CODES) file (File 1) of IBES data */

create table sig
	( 	sigcode    varchar2(6) not null,
		sectabrv   varchar2(8) not null,
		sectname   varchar2(24) not null,
		induabrv   varchar2(8) not null,          
		induname   varchar2(24) not null,
		grupabrv   varchar2(8) not null,
		grupname   varchar2(24) not null
	);

This page hosted by Get your own Free Home Page