SQL> 
SQL> select count(*)
   2     from smart_class c, smart_script s
   3    where c.id = s.smart_class_id
   4      and c.fk_id =  27708 
   5      and extractvalue(XMLType(s.script), '/TFastField/UpdTable/MasterField') is null
   6    /*   and extractvalue(XMLType(s.script), '/TFastField/UpdTable/MasterField') is not null */
SQL> /
 
  COUNT(*)
----------
         36 
 
SQL> 
SQL> select count(*)
   2     from smart_class c, smart_script s
   3    where c.id = s.smart_class_id
   4      and c.fk_id =  27708 
   5      and extractvalue(XMLType(s.script), '/TFastField/UpdTable/MasterField') is null
   6      and extractvalue(XMLType(s.script), '/TFastField/UpdTable/MasterField') is not null
   7   /
 
select count(*)
  from smart_class c, smart_script s
 where c.id = s.smart_class_id
   and c.fk_id =  27708 
   and extractvalue(XMLType(s.script), '/TFastField/UpdTable/MasterField') is null
   and extractvalue(XMLType(s.script), '/TFastField/UpdTable/MasterField') is not null
 
ORA- 31011 : сбой разбора XML
ORA- 19202 : Возникла ошибка при обработке XML 
LPX- 00210 : expected '<' instead of 's'
Error at line  1 
ORA- 06512 : на  "SYS.XMLTYPE", line  0 
ORA- 06512 : на  line  1