https://wiki.riguz.com/index.php?action=history&feed=atom&title=Oracle%3A%E8%BD%AC%E4%B9%89%E5%AD%97%E7%AC%A6 Oracle:转义字符 - 版本历史 2026-06-03T01:07:20Z 本wiki上该页面的版本历史 MediaWiki 1.42.3 https://wiki.riguz.com/index.php?title=Oracle:%E8%BD%AC%E4%B9%89%E5%AD%97%E7%AC%A6&diff=1415&oldid=prev imported>Soleverlee：​以“Oracle中查询遇到特殊字符时，需要进行转义： <source lang="sql"> select * from user_tables where table_name like 'T\_%' escape '\' </source> 这里...”为内容创建页面 2016-02-29T10:30:37Z <p>以“Oracle中查询遇到特殊字符时，需要进行转义： &lt;source lang=&quot;sql&quot;&gt; select * from user_tables where table_name like &#039;T\_%&#039; escape &#039;\&#039; &lt;/source&gt; 这里...”为内容创建页面</p> <p><b>新页面</b></p><div>Oracle中查询遇到特殊字符时，需要进行转义：<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> select * from user_tables where table_name like &#039;T\_%&#039; escape &#039;\&#039;<br /> &lt;/source&gt;<br /> <br /> 这里的&#039;\&#039;就用来转义&#039;_&#039;。<br /> <br /> 需要进行字符串连接时，使用&#039;||&#039;进行：<br /> &lt;source lang=&quot;sql&quot;&gt;<br /> select &#039;&lt;table tableName=&quot;&#039;||table_name||&#039;&quot;/&gt;&#039; from user_tables where table_name like &#039;T\_%&#039; escape &#039;\&#039;<br /> &lt;/source&gt;<br /> <br /> [[Category:Database]]</div> imported>Soleverlee