O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Unit 19.2. Reading Other Web Sites

Oracle provides an interesting package that allows PL/SQL to read Web pages like a text-only browser. This package is UTL_HTTP. UTL_HTTP reads HTML into a PL/SQL table or a VARCHAR2 variable. You are then free to analyze the resulting HTML source code.

A natural question is: Why would anyone be interested in analyzing the HTML of someone else’s Web site? There are numerous reasons. You might want to read a document, then, after having analyzed its contents, isolate the data you find most relevant, then load it into your database. You might also wish to read a document from your own site and save the text in the database. This saved text could serve as an audit trail of how the document source code changes over ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required