Next message: Longmire Carl-W14222: "RE: [LUNI] APIC messages on boot.."
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
This archive was generated by hypermail 2b29
: Mon Mar 12 2001 - 07:02:35 CST