<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[sunviolet9的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sunviolet9</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sunviolet9]]></copyright><item><title><![CDATA[贷记业务和借记业务]]></title><link>https://blog.youkuaiyun.com/sunviolet9/article/details/122620724</link><guid>https://blog.youkuaiyun.com/sunviolet9/article/details/122620724</guid><author>sunviolet9</author><pubDate>Fri, 21 Jan 2022 14:24:36 +0800</pubDate><description><![CDATA[贷记业务和借记业务]]></description><category></category></item><item><title><![CDATA[Oracle拼接字符串的两种方式]]></title><link>https://blog.youkuaiyun.com/sunviolet9/article/details/86649434</link><guid>https://blog.youkuaiyun.com/sunviolet9/article/details/86649434</guid><author>sunviolet9</author><pubDate>Fri, 25 Jan 2019 17:34:17 +0800</pubDate><description><![CDATA[1.listagg

     该方法拼接后是varchar2类型，有最大长度限制，在Oracle Database中，VARCHAR2 字段类型，最大值为4000；PL/SQL中 VARCHAR2 变量类型，最大字节长度为32767。

     适用场景：当要拼接的字符较少时使用。


select 'select ' ||col|| ' from ' || table_name ||';'
...]]></description><category></category></item></channel></rss>