Oracle PL/SQL/System Packages/UTL HTTP

Use UTL_HTTP package to load a website to a table

   <source lang="sql">

set serveroutput on size 200000

CREATE TABLE http_results (

 sequence_no NUMBER PRIMARY KEY,
 piece VARCHAR2(2000));
 

DECLARE

 myResult UTL_HTTP.HTML_PIECES;
 v_URL VARCHAR2(100) := "http://www.oracle.ru";
 v_Proxy VARCHAR2(100) := "YOUR_PROXY_SERVER";

BEGIN

 myResult := UTL_HTTP.REQUEST_PIECES(v_URL, 10, v_Proxy);
 FOR v_Count IN 1..10 LOOP
   INSERT INTO http_results VALUES (v_Count, myResult(v_Count));
 END LOOP;

END; / SELECT * FROM http_results

 ORDER BY sequence_no;
 

DROP TABLE http_results;

--

</source>