Re: SQL to extract and evaluate rows from multiple child rows and1 parent. (OT)

damorgan_at_exesolutions.com said...
> So the short version of what has turned into a very long answer ... is that I care a
> lot as do other instructors. I send my students to tahiti.oracle.com, I send them to
> asktom.oracle.com, I send them all over the internet for study support and research.
> I even encourage them to use these resources, class notes, class web site, and books
> when taking tests. But that is far different from passing exam questions to you or
> me or Tom and asking us to do their work. Does this make sense?
>
> Daniel Morgan
>

Thanks, Daniel. I apologize if I acted unethically in supplying an answer. It's very difficult (for me, at least) to determine if a question comes from a student or an employee (without them standing right in front of me where I can use body language to help make that determination).

Who's to say, for example, that recent NG questions about Oracle architecture (eg, LMT vs DMT, or SGA sizing) are not attempts by students of the local (Univ. Calif. San Diego) Oracle architecture class?

At my current employer (and at others as well), developers often come to me to ask a "simple" SQL question such as the one I answered. At first, I'm amazed that developers don't know the answer ... but, rather than tell them so, I answer their question. After all, I do love my current job and want to keep it. These developers could dance circles around my limited knowledge of Java; and I have to prove to them that PL/SQL can do almost anything in the database that Java can.

It's not just students who have trouble with SQL and PL/SQL.

I have 7 kids and 13 grandchildren, so I know students can sometimes opt for the easy way out. But I always try to follow a rule my mother taught me ... assume from the start that someone is good and honest.

But I do understand the predicament instructors are in. Hopefully, none of your students are brazen enough to cheat, knowing you're diligent in uncovering their deceit. And I do apologize if, in my ignorance, I do end up giving the answer to a student.

-- 
/Karsten