Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL question - rownum related
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
![]() |
![]() |