Human Resources and ELM - PSFT (MOSC)

MOSC Banner

Select xml with namespace

Hello I was used to write SQL to extract data from record containing xml , for exemple :
WITH XML AS
(SELECT xmltype(c.MyColumn_XML) AS OBJECT_VALUE,
myemployee
FROM myRecordwith_MyColumn_XML c
WHERE c.MyYear='2021'
AND (c.MyProvider ='MyProvider'))

select myemployee from XML

but with namespaces this sql doesn't retrieve data.
What is the solution ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center