-- Invocation de la fonction STAT_SUMMARY pour produire un rapport HTML
-- R.T. - 2014

SET DEFINE ON
SET TERMOUT OFF
SET LONG 10000
SET LONGC 10000
SET LINES 1000
SET HEAD OFF
SET VER OFF

COLUMN 3 NEW_VALUE 3

SELECT '' "3"
  FROM DUAL
WHERE 0 = 1;


DEFINE uname = '&3'


SET markup HTML ON HEAD "<style type='text/css'>body {font:10pt; background:white;}</style><title>Distribution &uname..&1 [&2]</title>" BODY "" TABLE "style='border:1px solid #000000;' cellpadding=10" SPOOL ON ENTMAP OFF PREFORMAT OFF

SPOOL stat_sum.html

SELECT stat_summary ('&1', '&2', '&uname', 'HTML')
  FROM DUAL;

SPOOL OFF

HOST stat_sum.html

SET MARKUP HTML OFF SPOOL OFF
SET TERMOUT ON
SET HEAD ON