Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating a relationship between 2 tables

Re: Creating a relationship between 2 tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 27 Jul 2006 02:11:55 -0700
Message-ID: <1153948341.650709@bubbleator.drizzle.com>


tony_becky_mikey_verizon_news wrote:

> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
> news:1153845184.892847_at_bubbleator.drizzle.com...

>> tony_becky_mikey_verizon_news wrote:
>>> "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..

>> No doubt you have a target painted on your back.
>>

>> I have a former student who was hired at a very large aerospace firm
>> who was reprimanded for working too hard and making the rest of the
>> team look bad. Government is often worse.
>> --
>> 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
> 
> 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.org
Received on Thu Jul 27 2006 - 04:11:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US