oracle8.1.6 select s.slide_title, s.sort_key, 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, to_char(ao.creation_date, 'HH24:MI, Mon DD, YYYY') as modified_date from cr_wp_slides s, cr_items i, acs_objects ao where i.item_id = :slide_item_id and i.live_revision = s.slide_id and ao.object_id = s.slide_id