
/* Code Fragment 9.16 Reconstruct the PROJECTIONS table as of now, as a view, on a temporally partitioned table. */

CREATE VIEW PROJECTIONS
	(PROJECTION_ID, PROJECTION_NAME, PROJECTION_TYPE, 
	 SPHEROID_CODE, PROJECTION_UOM, ZONE_CODE)
AS
SELECT  PROJECTION_ID, PROJECTION_NAME, PROJECTION_TYPE,
	SPHEROID_CODE, PROJECTION_UOM, ZONE_CODE
FROM P_TT_CURRENT
