Re: A Good Way to Create a Unique Key?

In article <azmoodehDAn94w.I9p_at_netcom.com>, azmoodeh_at_netcom.com (Hooman Azmoodeh) wrote:

> Hi,
> What is the best way to create a unique key for a table?

[clip]

If your running Oracle7, you can use a sequence, defined as:

    create sequence myseq;
You then retrieve a new sequence number like so:

    select myseq.nextval into :myvar from dual;

-- 
Peter Sylvester
MITRE Corp.
Bedford, MA
(peters_at_mitre.org)