Re: Question

From: <mpir_at_compuserve.com>
Date: 1998/03/11
Message-ID: <6e5a6s$r6t$1@nnrp1.dejanews.com>#1/1

In Oracle you can define a numeric field for the table and a sequence. The sequence can return a unique number. Use on On Insert trigger to assign the sequence.nextval to the numeric field;

In article <35047946.E6D7664A_at_ecitele.com>, Yacov Wolfowicz <yacovw_at_ecitele.com> wrote:
>
> 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...
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 11 1998 - 00:00:00 CST