如何在Oracle中计算字符串中的单词数? [英] How can I count the number of words in a string in Oracle?

问题描述

我正在尝试计算SQL字符串中有多少个单词.

I'm trying to count how many words there are in a string in SQL.

Select  ("Hello To Oracle") from dual;

我想显示字数.在给定的示例中，尽管单词之间可能有多个空格，但该单词将为3个单词.

I want to show the number of words. In the given example it would be 3 words though there could be more than one space between words.

推荐答案

您可以使用与此类似的内容.这将获取字符串的长度，然后减去空格后减去字符串的长度.然后在其上加上数字1，即可为您提供单词数:

You can use something similar to this. This gets the length of the string, then substracts the length of the string with the spaces removed. By then adding the number one to that should give you the number of words:

Select length(yourCol) - length(replace(yourcol, ' ', '')) + 1 NumbofWords
from yourtable

请参见带有演示的SQL小提琴

如果您使用以下数据:

CREATE TABLE yourtable
    (yourCol varchar2(15))
;

INSERT ALL 
    INTO yourtable (yourCol)
         VALUES ('Hello To Oracle')
    INTO yourtable (yourCol)
         VALUES ('oneword')
    INTO yourtable (yourCol)
         VALUES ('two words')
SELECT * FROM dual
;

查询:

Select yourcol,
  length(yourCol) - length(replace(yourcol, ' ', '')) + 1 NumbofWords
from yourtable

结果是:

|         YOURCOL | NUMBOFWORDS |
---------------------------------
| Hello To Oracle |           3 |
|         oneword |           1 |
|       two words |           2 |

这篇关于如何在Oracle中计算字符串中的单词数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！