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: SQL question - rownum related

Re: SQL question - rownum related

From: Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com>
Date: Thu, 03 Dec 1998 10:11:01 -0800
Message-ID: <3666D435.5AB94367@non-hp-usa-om46.om.hp.com>


PMG wrote:
>
> The reason I (think that I) want to do this is because NEWTABLE will be static -
> I don't expect to make changes to it very often.
> Also, NEWTABLE will be used as a reference table for ANOTHER_TABLE, and rather
> than storing the CITY string in ANOTHER_TABLE, I was just planning to store the
> ROWNUM value.
>
> Does this make sense? Any suggestions are welcome.
>
> Thanks,
>
> Pete
>

This could be a problem. If ANOTHER_TABLE is ever exported and imported all those ROWNUMS could/will be different than original. This will blow away the relations.

Michael Received on Thu Dec 03 1998 - 12:11:01 CST

Original text of this message

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