OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL & xml

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL & xml [message #638074]

Tue, 02 June 2015 02:26

sanodani
Messages: 98
Registered: October 2014

Member

Hallo All,

can anyone please help me, how can i (make select query)/select data from a coulumn of XMLtype in a Table?

Thank you in advance.
Regards,

Report message to a moderator

Re: SQL & xml [message #638076 is a reply to message #638074]

Tue, 02 June 2015 02:32

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Using XML functions.
Many examples in our JDeveloper, Java & XML forum.

Report message to a moderator

Re: SQL & xml [message #638087 is a reply to message #638076]

Tue, 02 June 2015 02:58

sanodani
Messages: 98
Registered: October 2014

Member

Thank you

Report message to a moderator

Re: SQL & xml [message #638101 is a reply to message #638087]

Tue, 02 June 2015 05:49

msol25
Messages: 396
Registered: June 2011

Senior Member

Hi Friend,

Please follow michel suggestions.For your quick reference you can use "extractvalue" function for fetching column value from xml.

[Updated on: Tue, 02 June 2015 05:49]

Report message to a moderator

Re: SQL & xml [message #638103 is a reply to message #638101]

Tue, 02 June 2015 06:00

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OP has already switched to " JDeveloper, Java & XML" forum and tries to use XMLTABLE function. Smile

[Updated on: Tue, 02 June 2015 06:03]

Report message to a moderator

Previous Topic:	Inserting mathematical symbol ≤ in Oracle table
Next Topic:	Question on Cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 30 16:10:53 CDT 2026