Re: ........H.E.LP. .M.E. .P.L.E.A.S.E............

From: Andrew Babb <andrewb_at_mail.com>
Date: Tue, 30 Mar 1999 09:44:30 +0800
Message-ID: <37002C7E.6C089B35@mail.com>

Within SQL*Plus you could use the SQLPLUS command BREAK.

Assuming that you have a STUDENT_ID, which is the column you want to break on (read new page) you could write the SQL*Plus script file as follows;

BREAK ON STUDENT_ID SKIP PAGE
SET PAGES 60
SET NEWPAGE 0
SET LINES 132
SET FEEDBACK OFF HEADING ON PAUSE OFF etc...

SELECT STUDENT_ID

     , COURSE
     , GRADE

  FROM COURSE
 ORDER BY STUDENT_ID, COURSE... Now each STUDENT_ID will appear on it's own page, but make sure that you order by the STUDENT_ID, because a new page comes every time the STUDENT_ID column changes in value.

Rgds
Andrew

JELIEL wrote:

> Ok I'm a SQL newbie, I know. Heres my problem, I'm using SQL*PLUS to create
> my database. Now I need to display school report cards ONE STUDENT PER
> PAGE....How do I get it to change pages after each student ?????? I'm
> completly in the dark here and my Oracle teacher really really really SUCKS
> ASS (pardon my french) So if anybody would be kind enough to help me out, it
> would be greatly aprreciated.
>
> Reply to my e-mail adresse < mailto:jeliel_at_videotron.ca>
>
> --
>
> JELIEL
>
> _________________________________________________________________________
>
> "What you do is what you get,
> Dont be suprised by that effect."
> (Ian Astbury)
>
> ICQ UIN: 2940070 (please state the nature of your ICQ contact demand)
>
> WEB PAGES:
>
> Jeliel : The Angel of Fire <http://members.xoom.com/_JELIEL_>
>
> Head Hunter <http://pages.infinit.net/jeliel>
>
> We are not human beings having a spiritual experience
> But rather we are spiritual beings having a human experience
> _________________________________________________________________________
Received on Mon Mar 29 1999 - 19:44:30 CST