Oracle資料庫select查詢, 有一個列存盤XML資訊. 如何寫運算式, 去掉一個: (1)<table>, (2)</table>,(3)以及<table>和</table>他們之間的資訊?
select
x,
y,
regexp_replace(xml,'xxx','')
from
xx
注：xml欄位為存盤xml資訊的欄位。某些記錄有table， 內容很大。 想在查詢階段就把table的資訊remove掉。
這里正則運算式應該怎么寫？ 謝謝。
示例：
<p>These issues include:</p>
<table class="striped">
<tbody>
<tr>
<td>CVE-2019-1010238</td>
<td>9.8 (<a href="https://cvssjs.github.io/#CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H">CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H</a>)</td>
<td>Gnome Pango 1.42 and later is affected by: Buffer Overflow. The impact is: The heap based buffer overflow can be used to get code execution. The component is: function name: pango_log2vis_get_embedding_levels, assignment of nchars and the loop condition. The attack vector is: Bug can be used when application pass invalid utf-8 strings to functions like pango_itemize.</td>
</tr>
<tr>
<td>CVE-2019-3462</td>
<td>8.1 (<a href="https://cvssjs.github.io/#CVSS:3.0/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H">CVSS:3.0/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H</a>)</td>
<td>Incorrect sanitation of the 302 redirect field in HTTP transport method of apt versions 1.4.8 and earlier can lead to content injection by a MITM attacker, potentially leading to remote code execution on the target machine.</td>
</tr>
<tr>
<td>CVE-2019-9924</td>
<td>7.8 (<a href="https://cvssjs.github.io/#CVSS:3.0/AV:L/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H">CVSS:3.0/AV:L/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H</a>)</td>
<td>rbash in Bash before 4.4-beta2 did not prevent the shell user from modifying BASH_CMDS, thus allowing the user to execute any command with the permissions of the shell.</td>
</tr>
</tbody>
</table>
]]></PROBLEM>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/230789.html
標籤：開發
上一篇：備份腳本
下一篇：開始學習資料分析