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
Post a Comment