Re: Question

From: joachim Carlsson <IKEA-joachim.carlsson_at_neurope.ikea.com>
Date: 1998/03/10
Message-ID: <6e34c9$8qc$1@mailgate.ikea.com>#1/1

Yes use sequences.

Regards
/Joachim
Yacov Wolfowicz wrote in message <35047946.E6D7664A_at_ecitele.com>...
>Hi,
>
>I need to translate a Microsoft SQL Server 6.5 to Oracle 7.3
>One of the fiels in a table is defined IDENTITY in SQL Server. It numbers a
>record automatically as you insert ther record, thus gives a unique id to
the
>record in the table.
>Is there something like it in Oracle?
>
>And in the same subject, how can i give a field a value which will be
unique
>over the entire database? I know there is a way to do it ( not using
rowid ) but
>can't figure a way to do it.
>
>Thanks in advance,
> Yaki
>
>--
>Life is hard
>and then you die...
>
>
Received on Tue Mar 10 1998 - 00:00:00 CST