Oracle PL/SQL/System Packages/UTL HTTP

Use UTL_HTTP package to load a website to a table

 
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;
 

--