Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating a relationship between 2 tables
tony_becky_mikey_verizon_news wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message > news:1153845184.892847_at_bubbleator.drizzle.com...
>>> "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... >>>>>> Andyza wrote: >>>>>>>> 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. >>>>>> I get the impression from your response to Ed that this is real work >>>>>> and not schoolwork: Amazing! >>>>>> >>>>>> If so polish up your resume and find a place to work where there is >>>>>> a whiff of competence. Learning bad practices is not a good career >>>>>> path. >>>>>> -- >>>>>> 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 >>>>> 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..
>>
> > Now you understand why I had my resume passed to you at the last Oracle days > in Bellevue. The IT situation here is bleak, and as long as want to > continue working with Oracle, I have to belong to the City's IT union and > such...
Run away ... run away. Check out the PSOUG Jobs Page. Things have been getting very active there for the last two months.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jul 27 2006 - 04:11:55 CDT