utilities-procs.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

 
<fullquery name="util_email_unique_p.email_unique_p">
  <querytext>
    select count(*)
    from dual
    where not exists (select 1
                      from parties
                      where email = lower(:email))
  </querytext>
</fullquery>

</queryset>