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: tony_becky_mikey_verizon_news <tony_becky_mikey_at_verizon.net>
Date: Tue, 25 Jul 2006 01:17:05 GMT
Message-ID: <liexg.7886$yN3.1914@trnddc04>

"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.. Received on Mon Jul 24 2006 - 20:17:05 CDT

Original text of this message

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