Re: Building a primary key

ORACLE dates don't get more grainy than seconds - maybe you could try doing a call to your OS??

What's wrong with using a sequence - say in a database trigger (ON ROW)??

• Martyn Senior ORACLE Analyst LGT Asset Management London UK

aramssb_svil <anpallotta_at_flashnet.it> wrote in article <333A7188.41C6_at_flashnet.it>...
> Hi there!!!
>
> I have a question that seem to be simple...
>
> I have to identify each row in my table with a unique key.
>
> In which way can i build this key without using a sequence???
>
> I heard a rumour about using a date, but i can't find the way to
> manipulate the date format of Oracle to obtain not seconds but fractions
> of this.
>
> If someone have some suggest, please e-mail me or post an answer.
>
> Thanks in advance
>
> ---
> Danilo Riccitelli & Andrea Pallotta
> Development Team - Digital Italy
>
Received on Thu Mar 27 1997 - 00:00:00 CST