Get cell name from XML file

[paulo79]

Hi all,

I have an oracle table with CLOB column type with this content below:

<?xml version="1.0" encoding="utf-8" ?>
<cli-output>
<version>1.0</version>
<timestamp>1646925662329</timestamp>
<context cell="celadm06"/>
<cell> <name>celadm06</name>
<accessLevelPerm>remoteLoginEnabled</accessLevelPerm>
<bbuStatus>normal</bbuStatus>
<cpuCount>96/96</cpuCount>
</cell>
</cli-output>

How can I create a python program to get <cell> <name> from that column in oracle table ?