the best way to extract parameters of a xml in oracle through select



I have a catalog in xml oracle but as extract value of a structure xml for example;





<Estaciones>
<Estacion>
<Nombre>Primavera</Nombre>
<Inicia>Marzo</Inicia>
<Termina>Septiembre</Termina>
</Estacion>
</Estaciones>



and so on for all seasons


Then make a select to compare each inicioMes and as a result the station


No comments:

Post a Comment