oracle8.1.6
select pres_title
from cr_wp_presentations p, cr_items i
where i.item_id = :pres_item_id
and i.live_revision = p.presentation_id
select 1+max(sort_key)
from cr_wp_slides s, cr_items i, cr_revisions r
where i.parent_id = :pres_item_id
and s.slide_id = i.live_revision
select wp_slide__get_bullet_items(:slide_item_id) as bullets_stored
from cr_wp_slides s, cr_items i
where i.item_id = :slide_item_id
and i.live_revision = s.slide_id
begin
:1 := wp_slide.new(
pres_item_id => :pres_item_id,
creation_user => :user_id,
creation_ip => :creation_ip,
creation_date => sysdate,
slide_title => :slide_title,
original_slide_id => -100,
sort_key => :sort_key,
preamble => :preamble,
postamble => :postamble,
bullet_items => :bullet_list,
package_id => :package_id
);
end;
begin
wp_slide.new_revision (
creation_user => :user_id,
creation_ip => :creation_ip,
creation_date => sysdate,
slide_item_id => :slide_item_id,
slide_title => :slide_title,
preamble => :preamble,
postamble => :postamble,
bullet_items => :bullet_items,
original_slide_id => :original_slide_id,
sort_key => :sort_key
);
end;
select s.slide_title,
s.sort_key,
s.original_slide_id,
wp_slide__get_preamble(:slide_item_id) as preamble,
wp_slide__get_postamble(:slide_item_id) as postamble,
wp_slide__get_bullet_items(:slide_item_id) as bullet_items
from cr_wp_slides s, cr_items i
where i.item_id = :slide_item_id
and i.live_revision = s.slide_id
select s.sort_key
from cr_wp_slides s, cr_items i
where i.item_id = :slide_item_id
and i.live_revision = s.slide_id