PostgreSQL到OracleSQL查询转换需要帮助(PostgreSQL to OracleSQL query convertion help needed)
我这里有一个PostgreSQL查询,它从“word”表列中计算大写字符:
sum(length(substring(word from '^[A-Z]*'))) as capitalized_sum;我需要将其转换为Oracle SQL查询。
我试过了:
sum(length(regexp_like('^[A-Z]*'))) from word as capitalized_sum;但这给了我“SQL命令没有正确结束”的消息。 有帮助吗?
I have a PostgreSQL query here that counts capitalized characters from a "word" table column:
sum(length(substring(word from '^[A-Z]*'))) as capitalized_sum;I need to convert it to Oracle SQL query.
I tried:
sum(length(regexp_like('^[A-Z]*'))) from word as capitalized_sum;but that gives me "SQL command not properly ended" message. Any help?
最满意答案
我想我找到了我需要的东西。 这是OracleSQL查询:
select sum(length(REGEXP_SUBSTR(word, '^[A-Z]*'))) as capitalized_sum from mytable;I think I found what I need. Here is the OracleSQL query:
select sum(length(REGEXP_SUBSTR(word, '^[A-Z]*'))) as capitalized_sum from mytable;更多推荐
发布评论