Joomla 3.1 Templates by FatCow Coupon

Как убить сессию запросом Oracle 11g Release 11.2

Категория: Блог Опубликовано 24.05.2017

следующий запрос убивает и вешает сессию наглухо

select x.id,
       rtrim(xmlagg(xmlelement("a",x.recno||';')).extract('//a/text()').getStringVal(),';') as recno,
       min(recno)
  from
  (select 1 as id, 101 as recno from dual
  union all
  select 2 as id, 102 as recno from dual
  union all
  select 3 as id, 103 as recno from dual
  union all
  select 3 as id, 123 as recno from dual
  union all
  select 4 as id, 104 as recno from dual
  union all
  select 5 as id, 105 as recno from dual) x
 group by x.id
 order by min(recno);
Просмотров: 281