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>