Attachment 1.2.4.  Create View and Query on Table 1 (summary) in Oracle


---------------------------------------------------------------
create view fy1 as (
	select 	* 
	from 	summary
	where	foreperi = 'FY 1' 
);


----------------------------------------------------------------
SELECT 		distinct ticker, numestis 
FROM  		summary 
WHERE 		statpyy = 96 
AND
		foreperi = 'FY 1'
ORDER BY	numestis
;

This page hosted by Get your own Free Home Page