Adam Leinss
asked on
SQL*PLUS - Oracle 8i - Report Making fun
I have following code:
set pagesize 60
set linesize 80
column today new_value _date noprint
select to_char(sysdate, 'fmMonth DD, YYYY') today
from dual;
column Member_Name format A12
column Volume format A7
ttitle center "Books Currently Checked Out" skip 1 -
center "Today's Date: " _DATE skip 1 -
skip center "Page:" format 999 sql.pno skip 2
SELECT Borrows_Call_No AS Call_No, Borrows_Vol AS Volume, Due_Date, Fine_Amount, Member_Name
FROM Member, Borrows
WHERE Borrows.Borrows_Member_ID = Member.Member_ID AND Borrows.Checked_In='N'
ORDER BY Fine_Amount DESC;
which produces this output:
Books Currently Checked Out
Today's Date: April 27, 2002
Page: 1
Books Currently Checked Out
Today's Date: April 27, 2002
Page: 1
CALL_NO VOLUME DUE_DATE FINE_AMOUNT MEMBER_NAME
---------- ------- --------- ----------- ------------
...
How can I have it just print out the title once?
Thanks!
set pagesize 60
set linesize 80
column today new_value _date noprint
select to_char(sysdate, 'fmMonth DD, YYYY') today
from dual;
column Member_Name format A12
column Volume format A7
ttitle center "Books Currently Checked Out" skip 1 -
center "Today's Date: " _DATE skip 1 -
skip center "Page:" format 999 sql.pno skip 2
SELECT Borrows_Call_No AS Call_No, Borrows_Vol AS Volume, Due_Date, Fine_Amount, Member_Name
FROM Member, Borrows
WHERE Borrows.Borrows_Member_ID = Member.Member_ID AND Borrows.Checked_In='N'
ORDER BY Fine_Amount DESC;
which produces this output:
Books Currently Checked Out
Today's Date: April 27, 2002
Page: 1
Books Currently Checked Out
Today's Date: April 27, 2002
Page: 1
CALL_NO VOLUME DUE_DATE FINE_AMOUNT MEMBER_NAME
---------- ------- --------- ----------- ------------
...
How can I have it just print out the title once?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.