'programming'에 해당되는 글 2건

  1. 2010.01.26 Ailge 개발을 위한 User Story Applied (1)
  2. 2009.05.08 Oracle : How to count repeated character in specific column?
Development2010.01.26 22:39

프로젝트를 하다 보면 방법론이라던가 스토리 텔링을 하는데 한계를 많이 느낀다.
어떻게 시나리오를 만들고 예측하는 것이 프로젝트에 도움이 되는 것일까?
더 많이 공부해야 함을 느끼는 요즈음

- NoPD -
Posted by 노피디
Development/Database2009.05.08 23:09
Last night, I have got request from my customer. He wanted to know how many XML nodes are there in XML log table placed in Oracle. I tried to find sufficient oracle function but couldn`t. So I make slightly dirty SQL query but it was very helpful to reduce manual job. Let`s see SQL query first.

SELECT xml_seq, 
       to_char((length(xml_recv)-length(replace(xml_recv,'<ITEM>',''))) / length('<ITEM>')) as item_count
  FROM tbl_xml_log
Look above SQL carefully. It looks dirty calculation about length of column but very simple. You can change <ITEM> to string that you want to count on specific column. It would be helpful for guys who want to count repeated character in specific column.

- NoPD -
Posted by 노피디

티스토리 툴바