CREATE TYPE PolyType AS ARRAY(5000) OF Point

CREATE TYPE Polygon AS OBJECT(
Num_of_point int,
Geometry polyType,
MEMBER FUNCTION Area(SELF IN) RETURN MEMBER,
PRAGMA RESTRICT_REFERENCES(Length,WNDS));

CREATE TABLE census_block (
block_id varchar(50),
area number,
population int,
shape Polygon)

Última modificación: Thursday, 24 de November de 2005, 15:31