hi friends,
Is there a function to count how many words does a varchar2 column contains?
Thanks
Printable View
hi friends,
Is there a function to count how many words does a varchar2 column contains?
Thanks
Hi
The answer is nope.
However depending upon your data you can try to use the avaliable string functions like length replace etc to get what you want.
regards
Hrishy
Number of spaces + 1?
Compare length of original string with length of string with spaces removed. Maybe regexp could do it also
thanks hunnies :)