Next message: Steven Lembark: "[LUNI] [Fwd: Please help, if you can. I hope you remember me.]"
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
This archive was generated by hypermail 2b29
: Mon Mar 12 2001 - 03:01:58 CST