Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating a relationship between 2 tables
"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1153692949.404846_at_bubbleator.drizzle.com...
> tony_becky_mikey_verizon_news wrote: >> "DA Morgan" <damorgan_at_psoug.org> wrote in message >> news:1153588495.761082_at_bubbleator.drizzle.com...
>>>>> You design is horrible. >>>> I know! That's how I inherited it! But gotta work with what we've got >>>> for now... >>>> >>>>> Why is SYSTEMID the PK for students and not STUDENTID? >>>> Because STUDENTID isn't guaranteed remain constant. And in some cases >>>> the STUDENTID might change over time. And some users might have more >>>> than one STUDENTID. It's used only for display purposes because users >>>> get a warm fuzzy feeling when they see it on reports... >>>> >>>>> You have gone pseudokey happy. >>>> Yeah! Is that a new drug? >>>> >>>>> This looks like a homework assignment, >>>> ROFLOreallyreallyL! Thank you. That made my day! >>>> >>>>> Look up the UPDATE statement. >>>>> (BIG HINT you will use a version that includes a subquery). >>>> That's what I've done since I posted the original message - a >>>> "sub-subquery" in a subquery in an update statement. It's awful... >>>> I'll post some code and "re-explain" myself.
>>>
>> >> Except if you want to work in Gov't.. This mentality (limited quality, >> more work) is what keeps developers there many years after they should >> have moved on.. Take it from someone who is witnessing it in real time!! > > Agreed. Then on the other hand the government employees all shrug > their shoulders and wonder why the tax payers want to lynch them. > > Well duh! > -- > Daniel A. Morgan > University of Washington > damorgan_at_x.washington.edu > (replace x with u to respond) > Puget Sound Oracle Users Group > www.psoug.org
Some of are different, but are getting lynched by our co-workers for wanting to change the way they have done stuff for 20 years.. Received on Mon Jul 24 2006 - 20:17:05 CDT