Oracle 10g 和 RSS 源
是否可以通过 rss feed 为 Oracle 10gR2 中的数据库提供数据？如果是这样我该如何开始呢？ 如果没有，我是否必须使用中介（即Java或其他东西）？
前提：
我正在尝试根据地震.usgs.gov 的提要开发一个地震事件数据库。使用他们的提要，我将能够维护近乎实时的事件数据库。我询问这条路线（RSS），因为我不想使用他们的软件（它的功能有限），而且我认为加州理工学院的男孩不会允许我连接到他们的数据库来提取所有相关的内容。
任何建议都很好，相关信息源的链接会更好，示例会很棒。
提前致谢。
Is feeding a db in Oracle 10gR2 from an rss feed possible? If so how do I start with this?
If not, do I have to use an intermediary (i.e. Java or something)?
The premise:
I am trying to develop an earthquake event database based on feeds from earthquakes.usgs.gov. Using their feed I would be able to maintain a near real time db of events. I ask about this route (RSS) because I don't want to use their software (it's limited in function) and I don't think the boys at caltech will allow me a connection to their DB to pull everything relevant.
any suggestions would be great, links to relevant information sources would be better, examples would be awesome.
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
绝对可以 - 并且您可以在 PL/SQL 中完成。
您可以使用 UTL_HTTP 获取原始提要并自己解析它；或者您可以使用 dbms_xmlparser，如本文所示：
http://technology.amis.nl/blog/1173/building-an-rss-feed-reader-in-plsql-using-utl_http- dbms_xmldom-and-dbms_xslprocessor-for-parsing-and-transforming
更好 - 您可以采用其他人的示例并根据您的要求进行自定义：http://ora-00001.blogspot.com/2011/02/fun-with-rss-and -plsql-part-one.html
Absolutely - and you can do it in PL/SQL.
You could use UTL_HTTP to grab the raw feed and parse it yourself; or you can use dbms_xmlparser as demonstrated in this article:
http://technology.amis.nl/blog/1173/building-an-rss-feed-reader-in-plsql-using-utl_http-dbms_xmldom-and-dbms_xslprocessor-for-parsing-and-transforming
Even better - you can just take someone else's example and customise it to your requirements: http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-one.html