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