Re: Oracle 10G

I must say it's different reading only half of the conversation. DM must have excellent students to have this much free time on his hands. cheers j. ----- Original Message ----- From: "Obnoxio The Clown" <obnoxio@hotmail.com> To: <informix-list@iiug.org> Sent: Tuesday, March 02, 2004 4:40 PM Subject: Re: Oracle 10G > Daniel Morgan wrote: > > > Obnoxio The Clown wrote: > > > >> Daniel Morgan wrote: > >> > >> You're the only one here who knows what an ASM or ADDM is. > >> > >> And cares, for that matter. > > > > Just in case there is one person out there that does: > > http://www.devx.com/dbzone/Article/17315 > > > > Surely you want to know what Mark's been doing in his spare time. > > "And cares, for that matter"... :o) > > I can only assume that this implies some degree off goodness that make > Oracle less of a PITA to manage. This is unlikely to be a huge priority for > Informixers -- we love what we do and don't get enough of it. > > Or looking after databases. > > -- > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche > sending to informix-list

Jack Parker wrote: > I must say it's different reading only half of the conversation. DM must > have excellent students to have this much free time on his hands. > > cheers > j. I do. The classes I teach are not for 20 year olds. To qualify for the Oracle classes requires a minimum of an undergraduate degree so the program attracts 90+% industry professionals looking for additional skills. Most already have 1 or 2 RDBMS products under their belt and many Java and C too. So 6 hours of lecture per week is all I have to do and the rest of my time is free for other pursuits and the weather is not yet conducive for sailing. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

Daniel Morgan wrote: > To qualify for > the Oracle classes requires a minimum of an undergraduate degree so > the program attracts 90+% industry professionals looking for > additional skills. Most already have 1 or 2 RDBMS products under > their belt and many Java and C too. So 6 hours of lecture per week > is all I have to do and the rest of my time is free for other pursuits > and the weather is not yet conducive for sailing. Yeah, that's true, Oracle is so difficult and incomprehensible, you do need to be a rocket scientist to work with it. And since NASA is not doing that well at the moment... -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1078334021.679183@yasure>... > Jack Parker wrote: > > > DM must have excellent students to have this much free time on his hands. > > > > cheers > > j. > > I do. The classes I teach are not for 20 year olds. To qualify for > the Oracle classes requires a minimum of an undergraduate degree so > the program attracts 90+% industry professionals looking for > additional skills. Most already have 1 or 2 RDBMS products under > their belt and many Java and C too. So they'd know really basic stuff then like about 9 not in (1, 2, 3, null) being false? :-O > From: Daniel Morgan (damorgan@x.washington.edu) > Subject: What is the difference? > View: Complete Thread (8 articles) > Original Format > Newsgroups: comp.databases.oracle.server > Date: 2003-09-28 13:36:11 PST > > > I know its [sic] Sunday and I should be out enjoying the 83 degree weather > with beautiful blue skies ... but my brain > is obviously fried as I can't figure out why these two SQL statements > produce different results form the exact > same data set. > > SELECT person_id > FROM person > WHERE app_status = 'RA' > AND gender = 'F' > AND person_id NOT IN ( > SELECT DISTINCT candidate_id > FROM examiner_candidate_ie);> -- returns 0 rows > > SELECT person_id > FROM person p > WHERE app_status = 'RA' > AND gender = 'F' > AND NOT EXISTS ( > SELECT candidate_id > FROM examiner_candidate_ie > WHERE candidate_id = p.person_id);> -- returns the correct 17 rows

Obnoxio The Clown wrote: > Yeah, that's true, Oracle is so difficult and incomprehensible, you do need > to be a rocket scientist to work with it. And since NASA is not doing that > well at the moment... What is difficult for some ... is easy for others. The difficulty in the program is not the database. The course would be equally difficult taught with any RDBMS. The difficulty is that we teach problem solving skills: Not just syntax. Here's a problem given to students last night. As solvable in Informix as in Oracle: Go for it. ==================================================================== Two mathematicians (Boris and Vladimir) met accidently for the first time in 20 years. They greet each other and begin catching up on their respective lives. Boris asks Vladi "Do you have any children?" "Yes" replies Vladimir, "I have three." "How old are they?", asks Boris. "The product of their ages is 36 and the sum of their ages is equal to the number of windows on that building across the street." Boris looks at the building, counts the windows then says "Vladi, that still doesn't tell me the ages." "Ah, says Vladi, then I must tell you that the eldest has red hair." "Oh", says Boris, "now I know their ages." What are the ages of Boris' children? ==================================================================== Create a table, load it with data, and write a single SQL statement to produce the data set required to deduce the answer ... then deduce away! -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)