urgent! SQL statement to query xml data type
Hi,guys. Thanks first for viewing. Hope to get help from here.Im new to XML.
Below is the data stored in database table under field [Root_Cause_Analysis]
The volume and keypad related features
in multi-ch behavior has been
discussed for very long time. Recently,
we received the final decision from
To increase discussion effectiveness
My problem is how to select all the data inside tag?
Ex: Select Root_cause_analysis(RCA/PREVENTION) From table1....
and the result should show "To increase discussion effectiveness