Home » SQL & PL/SQL » SQL & PL/SQL » count of commas
count of commas [message #236077] Wed, 09 May 2007 00:22 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
i have  one string 

name
ab,a,wwer,errrr,asd,mnbc

i want to count of commas(',')

o/p
5

[Updated on: Wed, 09 May 2007 00:23]

Report message to a moderator

Re: count of commas [message #236081 is a reply to message #236077] Wed, 09 May 2007 00:28 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you search for "number of occurrence", you would have found this post (number 10 in result list)
Re: count of commas [message #236113 is a reply to message #236081] Wed, 09 May 2007 01:15 Go to previous message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
thanks frank
Previous Topic: Cursors
Next Topic: List schema tables in dependency order
Goto Forum:
  


Current Time: Tue Dec 06 10:21:09 CST 2016

Total time taken to generate the page: 0.10679 seconds