XML contains and extract

Being fairly new to Oracle and XML can anyone compare and contrast the following two statements with regard to performance etc .

SELECT 1
FROM xml_table
WHERE EXTRACT(xml_text, '*/username/text()')getstringval() = 'FRED'

SELECT 1
FROM xml_table
WHERE CONTAINS(xml_text, 'FRED within username') > 0

Thanks

Steve Received on Tue Jan 25 2005 - 06:10:54 CST