oracle8.1.6
select community_id
from dotlrn_communities_all
where package_id = :package_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
dotlrn_community_type.del(
community_type => :community_type_key
);
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 community_type
from dotlrn_communities
where community_id = :community_id
select dotlrn_community_types.community_type
from dotlrn_community_types
where dotlrn_community_types.tree_sortkey = (select tree.ancestor_key(dotlrn_communities.tree_sortkey, 1)
from dotlrn_communities
where dotlrn_communities.community_id = :community_id)
select dotlrn_community_types.community_type
from dotlrn_community_types
where dotlrn_community_types.tree_sortkey = (select tree.ancestor_key(dct.tree_sortkey, 1)
from dotlrn_community_types dct
where dct.community_type = :community_type)
select community_id,
community_key,
pretty_name,
archived_p,
dotlrn_community.url(community_id) as url
from dotlrn_communities_all
where parent_community_id = :community_id
and archived_p = 'f'
order by pretty_name
select from_addr,
subject,
email
from dotlrn_member_emails
where (enabled_p='t' or :override_enabled_p = 1)
and community_id = :community_id
and type = :type