gpt4 book ai didi

oracle - 如何删除或跳过字符串中的多个新行?

转载 作者:行者123 更新时间:2023-12-04 01:15:57 27 4
gpt4 key购买 nike

DECLARE
v_string VARCHAR2(4000) := 'A database is an organized collection of data,
generally stored and accessed electronically
from a computer system. Where databases are more



complex they are often developed
using formal design and modeling techniques.';
v_sql_code_new VARCHAR2(4000);
BEGIN
END;
/

Desired output:
A database is an organized collection of data,
generally stored and accessed electronically
from a computer system. Where databases are more
complex they are often developed
using formal design and modeling techniques.

我正在尝试从字符串中删除所有换行符。我尝试使用 regexp_replace 但无法获得所需的结果。先谢谢你

最佳答案

虽然您也可以将 '^\s*$'modifier=>'mn' 一起使用,但最简单的方法是替换多个 chr(10):

DECLARE
v_string VARCHAR2(4000) := 'A database is an organized collection of data,
generally stored and accessed electronically
from a computer system. Where databases are more



complex they are often developed
using formal design and modeling techniques.';
v_sql_code_new VARCHAR2(4000);
BEGIN
dbms_output.put_line(regexp_replace(v_string,chr(10)||'(\s*'||chr(10)||')+',chr(10)));
END;
/

\s* 这里只是删除只包含空格字符的行。

关于oracle - 如何删除或跳过字符串中的多个新行?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/63383910/

27 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com