Home » SQL & PL/SQL » SQL & PL/SQL » how to store xml in blob from a query. (2 Merged)
how to store xml in blob from a query. (2 Merged) [message #560507] Fri, 13 July 2012 14:21 Go to next message
rajeshrajdaan
Messages: 16
Registered: July 2012
Junior Member
Dear all

i want to store xml in database. i have following questions,
1) in which col should i keep xml .
2) right now i am keeping it in blob columns, so please tel me how can i insert update a record in blob col from query, which can be run from worksheet.

I am using oracle 11g express edition.

yours sincerely

Report message to a moderator

Re: how to store xml in blob from a query. [message #560509 is a reply to message #560507] Fri, 13 July 2012 14:24 Go to previous messageGo to next message
Solomon Yakobson
Messages: 1398
Registered: January 2010
Senior Member
You should keep XML in a column of XMLTYPE datatype.

SY.

Report message to a moderator

Re: how to store xml in blob from a query. [message #560537 is a reply to message #560509] Sat, 14 July 2012 01:01 Go to previous message
Michel Cadot
Messages: 54164
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... (to add) and the reason is that you can't update the blob unless you read it as a whole in your program, modify it in your program and restore it.
With XMLTYPE you can built-in XML functions in SQL and PL/SQL.

Regards
Michel

Report message to a moderator

Previous Topic: using where not exists against a list of values....pls help
Next Topic: pl/sql stored procedure execute/return value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 11:30:09 CDT 2013

Total time taken to generate the page: 0.14877 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.