실습6. 보고서 형식
Posted 2008/10/15 16:28, Filed under: 학과수업들/DB 프로그래밍실습6.
3번 쿼리문
SET ECHO OFF
SET PAGES 28
SET LINES 70
SET FEEDBACK OFF
TTI CENTER 'Sales Representatives' SKIP 1 CENTER 'And Customers' SKIP 2
BTI RIGHT 'Page' SQL.PNO SKIP 1
COL "Sales Rep" FORMAT A30
COL name HEA 'Customer' FORMAT A30
BREAK ON "Sales Rep" SKIP 1 ON REPORT
COMPUTE COUNT LABEL 'TOTAL CUSTOMERS' OF name ON REPORT
select upper(s_emp.last_name) || ' is the rep for' "Sales Rep", s_customer.name from s_emp, s_customer where s_emp.id = s_customer.sales_rep_id order by s_emp.last_name, s_customer.name
/
4번 쿼리문
SET ECHO OFF
SET PAGES 45
SET LINES 55
SET FEEDBACK OFF
TTI 'Sales|Report'
COL "Sales Rep" HEA 'Sales|Rep' FORMAT 9999999
COL "Customer name" HEA 'Customer|name' FORMAT A20
COL "Order Date" HEA 'Order|Date' FORMAT A10
COL "Total" FORMAT $9,999,999.99
BREAK ON "Sales Rep" SKIP 1 ON REPORT ON "Customer name" ON NODUP
COMPUTE SUM LABEL 'sum' OF "Total" ON "Sales Rep"
COMPUTE SUM LABEL 'sum' OF "Total" ON REPORT
select o.sales_rep_id "Sales Rep", upper(c.name) "Customer name", to_char(o.date_ordered, 'mm/dd/yy') "Order Date", o.total "Total" from s_ord o, s_customer c where o.customer_id=c.id order by "Sales Rep", "Customer name"
/
Trackback URL : http://mysilpir.net/trackback/320
