oracle8.1.6
select dotlrn_communities.community_id
from dotlrn_communities,
(select site_nodes.object_id
from site_nodes
where exists (select 1
from dotlrn_communities dc
where dc.package_id = site_nodes.object_id)
and rownum = 1
start with site_nodes.node_id = (select sn.node_id
from site_nodes sn
where sn.object_id = :package_id)
connect by prior site_nodes.parent_id = site_nodes.node_id) packages
where dotlrn_communities.package_id = packages.object_id
declare
begin
:1 := dotlrn_community_type.new(
community_type => :community_type_key,
parent_type => :parent_type,
pretty_name => :pretty_name,
pretty_plural => :pretty_name,
description => :description
);
end;
declare
begin
:1 := dotlrn_community.new(
community_type => :community_type,
community_key => :name
pretty_name => :pretty_name,
pretty_plural => :pretty_name,
description => :description
);
end;
declare
begin
dotlrn_community.set_active_dates(
community_id => :community_id,
start_date => to_date(:start_date, :date_format),
end_date => to_date(:end_date, :date_format)
);
end;
select site_node.url(node_id)
from site_nodes
where parent_id = :current_node_id
and object_id= :package_id
select site_node.url(node_id)
from site_nodes
where object_id = :package_id
select community_type
from dotlrn_communities
where community_id = :community_id
select object_type
from acs_object_types
where supertype = 'dotlrn_community'
start with object_type = (select community_type
from dotlrn_communities
where parent_community_id is null
and community_type != 'dotlrn_community'
start with community_id = :community_id
connect by community_id = prior parent_community_id)
connect by object_type = prior supertype
select object_type
from acs_object_types
where supertype = 'dotlrn_community'
start with object_type = :community_type
connect by object_type = prior supertype