Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

path query to Xquery

NinaOracleOct 24 2012 — edited Oct 25 2012
if I have this xmltable



CREATE TABLE xmltable OF XMLType;

INSERT INTO xmltable VALUES (XMLType('<root><listing>

<seller_info>

<seller_name> cubsfantony</seller_name>

<seller_rating> 848</seller_rating>

</seller_info>

<payment_types>Visa/MasterCard, Money Order/Cashiers Checks, Personal Checks, See item description for payment methods accepted

</payment_types>

<shipping_info>Buyer pays fixed shipping charges, Will ship to United States only

</shipping_info>

<buyer_protection_info>

</buyer_protection_info>

<auction_info>

<current_bid>$620.00 </current_bid>

<time_left> 4 days, 14 hours + </time_left>

<high_bidder>

<bidder_name> gosha555@excite.com </bidder_name>

<bidder_rating>-2 </bidder_rating>

</high_bidder>

<num_items>1 </num_items>

<num_bids> 12</num_bids>

<started_at>$1.00 </started_at>

<bid_increment> </bid_increment>

<location> USA-Chicago</location>

<opened> Nov-27-00 04:57:50 PST</opened>

<closed> Dec-02-00 04:57:50 PST</closed>

<id_num> 511601118</id_num>

<notes> </notes>

</auction_info>

<bid_history>

<highest_bid_amount>$620.00 ; </highest_bid_amount>

<quantity> 1</quantity>

</bid_history>

<item_info>

<memory> 256MB PC133 SDram</memory>

<hard_drive> 30 GB 7200 RPM IDE Hard Drive</hard_drive>

<cpu>Pentium III 933 System </cpu>

<brand> </brand>

<description> </description>

</item_info>

</listing></root>'

));



I want to retrieve the path query //auction_info[current_bid=" $610.00";][num_items=" 1"][started_at=" $100.00";]/time_left

in XQuery or using other operators

as

Select extract(OBJECT_VALUE,'//auction_info[current_bid=" $610.00";][num_items=" 1"][started_at=" $100.00";]/time_left')

from xml_table;

but it does not work, How I write the right query for this path

regards
<div id="isChromeWebToolbarDiv" style="display:none"></div>

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2012
Added on Oct 24 2012
1 comment
1,234 views