oracle生成报表语句

e.g 1

set linesize 200
set pagesize 200
set term off feedback off
set markup html on entmap on preformat off
spool f:people_report.xls
select * from people;
spool off
set term on feedback on
set markup html off entmap off preformat on

 

 

e.g 2

 

 

SET ECHO OFF
SET VERIFY OFF
TTITLE 'Customer History Report'
BREAK ON member SKIP 1 ON REPORT
SELECT   m.first_name||' '||m.last_name MEMBER, t.title, 
r.book_date, r.act_ret_date - r.book_date DURATION
FROM     member m, title t, rental r
 WHERE     r.member_id = m.member_id 
AND     r.title_id = t.title_id
 ORDER BY   member;
 CLEAR BREAK
 TTITLE OFF
SET VERIFY ON
SET ECHO ON