bookmarks-init-oracle.xql

DB Query file

Related Files

• packages/bookmarks/tcl/bookmarks-init.xql
• packages/bookmarks/tcl/bookmarks-init.tcl
• packages/bookmarks/tcl/bookmarks-init-postgresql.xql
• packages/bookmarks/tcl/bookmarks-init-oracle.xql

[ hide source ]

File Contents

<?xml version="1.0"?>

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

<fullquery name="bm_packages">      
      <querytext>
      
    select site_node.url(node_id) as path
    from   site_nodes
    where  object_id in (select package_id
                         from   apm_packages where package_key = 'bookmarks')

      </querytext>
</fullquery>
 
<fullquery name="bm_clean_up_session_data.delete_old_in_closed_p">      
      <querytext>
      delete from bm_in_closed_p where creation_date < (sysdate - :max_days)
      </querytext>
</fullquery>

 
</queryset>