Next message: Martin Maney: "Re: [LUNI] Fujitsu MO media"
You are the best. I was searching for HOURS on Google last night trying
to find something exactly like this, but was thwarted at every turn. I
think you just saved my grade.
Thanks!
On Mon, 12 Mar 2001, Jack Beglinger wrote:
>
> Your answer is here...
> http://www.arsdigita.com/books/sql/trees.html
>
> > Hello all--
> >
> > Sorry, I know this is the second time I've bothered you all about this,
> > but I need another SQL question answered, so I figured I'd ask.
> >
> > I have a table called "exercises". This table is supposed to contain
> > names of various exercises along with the id#'s of other exercises they're
> > a part of (I.E. Jumping Jacks is part of Aerobics, etc.) What I need to
> > do is print out the routines (in this example, Aerobics) followed by all
> > the exercises that are a part of it (i.e. Jumping Jacks, toe touches,
> > etc. that would be a part of this routine), followed by the next routine,
> > followed by the exercises that are a part of it, etc. I need to have the
> > exercise name field indented if the exercise is a part of a routine
> > (which I also don't know how to do).
> >
> > Here's the describe of the table:
> >
> > SQL> describe user2.exercises
> > Name Null? Type
> > ------------------------------- -------- ----
> > EXNAME NOT NULL CHAR(15)
> > EX# NOT NULL CHAR(4)
> > DESCRIPTION NOT NULL CHAR(25)
> > ISPARTOF CHAR(4)
> >
> > SQL>
> >
> > According to my prof, the correct answer has columns "Exercise #" and
> > "Exercise Name". Not a big deal.
> >
> > Here's the main questions:
> >
> > 1) How do I use the "Connect By" clause to do this?
> > 2) How do I use "level" to get the routines and exercises to do what I
> > need them to do?
> >
> > I'm sorry if I'm not entirely clear. It is 3am...
> >
> > Thanks for all your help. I really do appreciate any assistance I can
> > get.
> >
> > Tim
> >
> >
> >
> > *************************************************************************** *
> > Timothy Wielgos * "I believe in Christianity as I * *
> > Computer Technician, aspiring * believe that the sun rises. Not * *
> > world dictator. * because I see it, but by it I can * *
> > wiggles@xnet.com * see everything else" * *
> > wiggles@death-star.com * --C.S. Lewis * *
> > http://bobcat.bradley.edu/~wiggles * * * AIM:
> > Weeglos * *
> > *************************************************************************** "An
> > infinite number of monkies pounding on typewriters could turn out Shakespeare.
> > Microsoft? Sixteen monkeys sharing a fountain pen and a case of beer. Take
> > away the pen and you've got ZDNet."
> > --Anonymously posted on http://slashdot.org
> >
> > -=-
> > Linux Users Of Northern Illinois: General Discussion Mailing list.
> > For unsubscription, archives, and announcements only see http://luni.org
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> -=-
> Linux Users Of Northern Illinois: General Discussion Mailing list.
> For unsubscription, archives, and announcements only see http://luni.org
>
***************************************************************************
* Timothy Wielgos * "I believe in Christianity as I *
* Computer Technician, aspiring * believe that the sun rises. Not *
* world dictator. * because I see it, but by it I can *
* wiggles@xnet.com * see everything else" *
* wiggles@death-star.com * --C.S. Lewis *
* http://bobcat.bradley.edu/~wiggles * *
* AIM: Weeglos * *
***************************************************************************
"An infinite number of monkies pounding on typewriters could turn out
Shakespeare. Microsoft? Sixteen monkeys sharing a fountain pen and a
case of beer. Take away the pen and you've got ZDNet."
--Anonymously posted on http://slashdot.org
-=-
Linux Users Of Northern Illinois: General Discussion Mailing list.
For unsubscription, archives, and announcements only see http://luni.org
This archive was generated by hypermail 2b29
: Mon Mar 12 2001 - 12:14:52 CST