new.xql
DB Query file
Related Files
- packages/acs-subsite/www/admin/rel-segments/constraints/new.xql
- packages/acs-subsite/www/admin/rel-segments/constraints/new.tcl
- packages/acs-subsite/www/admin/rel-segments/constraints/new.adp
- packages/acs-subsite/www/admin/rel-segments/constraints/new-postgresql.xql
- packages/acs-subsite/www/admin/rel-segments/constraints/new-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?>
<queryset>
<fullquery name="select_segments">
<querytext>
select s.segment_name, s.segment_id
from application_group_segments s
where s.segment_id <> :rel_segment
and s.package_id = :package_id
order by lower(s.segment_name)
</querytext>
</fullquery>
</queryset>