Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL*PLUS - Oracle 8i - Report Making fun

Posted on 2002-04-27
1
Medium Priority
?
771 Views
Last Modified: 2007-12-19
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!
0
Comment
Question by:Adam Leinss
1 Comment
 
LVL 7

Accepted Solution

by:
waynezhu earned 200 total points
ID: 6974433
Adding a TTITLE OFF as below:

set pagesize 60
set linesize 80

ttitle off             -- clear

column today new_value _date noprint
select to_char(sysdate, 'fmMonth DD, YYYY') today
from dual;
.
.
.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question