Urgent :)

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 :)