Question

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...