Oracle 10g: Extract data (select) from XML (CLOB Type)?

Try this instead: select xmltype(t. Xml). Extract('//fax/text()').getStringVal() from mytab t.

Not yet:ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS. XMLTYPE", line 254 ORA-06512: at line 1 – mymark Feb 3 at 10:02 how are you inserting the xml? – dogbane Feb 3 at 10:22 Sorry.... yes, your answer work perfectly!

In previous case I've got an xml null ^^! – mymark Feb 3 at 12:47 In 11g I can leave .getStringVal()-part out. No idea about 10g as I don't have any here.

– user272735 May 27 at 6:22.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.