Re: Does Oracle has an automatic counter field data type?

André Klück wrote:

> Sami adn Andrea,
>
> Beware, the ROWID is NOT a constant trough all times!
> An export and import for instance will ruine your primary key if
> you use ROWID. So ALLWAYS use a SEQUENCE.
>
> sUCCes,
> André

Yes, I know it, so you don't reference ROWID in other OBJECT permanently, but you can use it in SQL-statements executed in procedure or trigger whenever you need an unique key for every row .

Hi, Andrea

-

           \\\\////
           &( oo )&
========oOO==(__)==OOo========
|                            |
|Andrea.Cannaos_at_deagostini.it|
|                            |
==============================
            ||   ||
           (__) (__)