Database » Ask Tom MOST RECENT ARTICLES » Hierarchal Queries with Aggregates.

Feeds

15142 items (92 unread) in 26 feeds

Database (92 unread)

• DBA's notes (6 unread)
• $Pete Finnigan's Oracle security weblog (1 unread)
• Ask Tom MOST RECENT ARTICLES (38 unread)
• Databases News (3 unread)
• DBAzine.com - Oracle Articles Archive
• Eddie Awad's Blog (3 unread)
• FeuerThoughts (1 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog
• MySQL Performance Blog (9 unread)
• Niall's Oracle Pages
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions
• Oracle Security Alerts
• Oracle Software Downloads
• Oracle Technology News
• Oracle's OTN TechCasts (2 unread)
• Orawin.Info
• OTN TechBlog
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (3 unread)
• TheServerSide.com (26 unread)
• Upcoming Security Alerts

Ask Tom MOST RECENT ARTICLES

• October 01, 2008
• 

  Hierarchal Queries with Aggregates.

  Fetched: September 30th, 2008, 7:24am PDT

  Tags:    [edit]

  Hi Tom, To count the Number of Delimiters in a Given string i use the below query. SELECT COUNT(DECODE(LEVEL,0,NULL,LEVEL)) COUNT_DELIMIT FROM DUAL CONNECT BY INSTR('1,2,3,4,5,6,,',',',1,LEVEL) >0 but i used the same query in the...