oracle8.1.6 begin :1 := dynamic_type.create_type ( :name, :supertype, :pretty_name, :pretty_plural, :table_name, :id_column, :name_method ); end; begin :1 := dynamic_type.drop_type ( :name, :drop_children, :drop_table ); end begin :1 := dynamic_type.create_attribute ( :object_type, :name, :datatype, :pretty_name, :pretty_plural, :sort_order, :default_value, :column_spec ); end begin :1 := dynamic_type.drop_attribute ( :object_type, :name, :drop_column ); end select a.attribute_name as name, a.pretty_name, a.attribute_id, a.datatype from acs_object_type_attributes a, (select t.object_type, level as type_level from acs_object_types_t start with t.object_type = :start_with connect by prior t.object_type = t.supertype) t where a.object_type = :name and t.object_type = a.ancestor_type $storage_clause order by type_level, a.sort_order