content-item-procs-oracle.xql

DB Query file

Related Files

• packages/acs-content-repository/tcl/content-item-procs.xql
• packages/acs-content-repository/tcl/content-item-procs.tcl
• packages/acs-content-repository/tcl/content-item-procs-postgresql.xql
• packages/acs-content-repository/tcl/content-item-procs-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

  <fullquery name="content::item::content_is_null.cin_get_content">
    <querytext>
      select 't' from cr_revisions r, cr_items i
      where r.revision_id = :revision_id
      and i.item_id = r.item_id
      and ((r.content is not null and i.storage_type in ('lob','text')) or
      (r.filename is not null and i.storage_type = 'file'))
    </querytext>
  </fullquery>

  <partialquery name="item::get_revision_content.grc_get_all_content_1">
    <querytext>
      , content.blob_to_string(content) as text
    </querytext>
  </partialquery>

</queryset>