oracle11g - XML or String function in Oracle -


i need find solution following. have xml files stored in 1 of columns of table , need extract hasnumber same file following conditions.

if there file got <identification> along <impurities> or <additives> no hasnumber selected.

if there <identification> without impurities or additive tag hasnumbers should selected.

1) don’t select hasnumber following condition

 <identification><impurities> <hasnumber>1113-22-1</hasnumber>  <identification> <'additives> <hasnumber>1113-22-1</hasnumber> 

2) select hasnumber following condition

<identification> <hasnumber>1113-22-1</hasnumber> 


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -