XMLType primary key

From: Albert Greinöcker <albert.greinoecker_at_uibk.ac.at>
Date: Fri, 28 Oct 2005 09:40:38 +0200
Message-ID: <4361d5f7$1@sia.uibk.ac.at>

Hi NG,

I have a question concerning Oracle's XmlType. How can I use a similar constraint like a primary key within an XMLType entry? In other words: I would like to store documents as XML which do have an unique id (which is an attribute of the root element), e.g.
<METS>

<metsHdr ID="0001">
</metsHdr>
</METS>

How can I assure that the column does not already contain a document with ID 0001
(without using triggers or storing the id in another column)?

thx,
Albert Received on Fri Oct 28 2005 - 02:40:38 CDT