Re: SQL question - rownum related

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

"Alan D. Mills" wrote:

> Ok, you now have a solution. However, I'm wondering why you want to do
> this. It looks, to me, like the ROWNUM value you're retrieving is going to
> be used as the primary key in your new table. If so then what does it
> matter if they are not in order. As soon as you add a new one with the next
> number the chances are that they will be out of sequence anyway, unless the
> new city start with a 'Z' or something.
>
> --
> Alan D. Mills
>
> PMG wrote in message <36662471.22979B4C_at_2xtreme.net>...
> >You are so right. Thanks for your version. It's amazing how often one finds
> a
> >complicated route when a much simpler route is right in front of his nose.
> >
Received on Thu Dec 03 1998 - 11:00:16 CST