Home » SQL & PL/SQL » SQL & PL/SQL » Count and place of occurence of a string
Count and place of occurence of a string [message #205751] Mon, 27 November 2006 06:17 Go to next message
katejinu
Messages: 7
Registered: May 2006
Junior Member
Could you tell me how get the count and place of occurence of a word in astring?

For Eg: string1 ='hello how how are you? how is ur wife?'

Here,I want to get the count and palce of occurence of 'how'.

Thanks,

Kate
Re: Count and place of occurence of a string [message #205756 is a reply to message #205751] Mon, 27 November 2006 06:51 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Attack of the clones?
Re: Count and place of occurence of a string [message #205758 is a reply to message #205756] Mon, 27 November 2006 07:10 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Homework's due, I guess.
Re: Count and place of occurence of a string [message #205761 is a reply to message #205758] Mon, 27 November 2006 07:41 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You'd better search for occurrences of 'your' instead!
Re: Count and place of occurence of a string [message #205851 is a reply to message #205756] Mon, 27 November 2006 23:04 Go to previous messageGo to next message
katejinu
Messages: 7
Registered: May 2006
Junior Member
Thanks a million...
Re: Count and place of occurence of a string [message #205856 is a reply to message #205756] Mon, 27 November 2006 23:12 Go to previous message
katejinu
Messages: 7
Registered: May 2006
Junior Member
But what I need is the count of a particular word. Not one character. The querry is not working for the occurence of a word in a string.

Thanks..
Previous Topic: Slow Output of Oracle
Next Topic: SQL Help
Goto Forum:
  


Current Time: Mon Dec 05 08:41:49 CST 2016

Total time taken to generate the page: 0.16478 seconds