bookmark-view-oracle.xql

DB Query file

Related Files

• packages/bookmarks/www/bookmark-view.xql
• packages/bookmarks/www/bookmark-view.tcl
• packages/bookmarks/www/bookmark-view.adp
• packages/bookmarks/www/bookmark-view-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="bookmark_view">      
      <querytext>
	select local_title,
               email,
               owner_id,
               complete_url, 
               bookmark_id,
               meta_keywords,
               meta_description,
               url_title
        from   bm_bookmarks, 
               bm_urls,
               parties
        where  bookmark_id = :bookmark_id
        and    bm_bookmarks.url_id = bm_urls.url_id(+)
        and    bm_bookmarks.owner_id = parties.party_id      
	</querytext>
</fullquery>

 
</queryset>