Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Question
On Tue, 10 Mar 1998 11:12:34 +0100, "joachim Carlsson" <IKEA-joachim.carlsson_at_neurope.ikea.com> wrote: Hi,
and triggers.
>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...
>>
>>
>
>
-- Regards Matthias Gresz :-) GreMa_at_T-online.deReceived on Tue Mar 10 1998 - 00:00:00 CST