A Good Way to Create a Unique Key?

From: Hooman Azmoodeh <azmoodeh_at_netcom.com>
Date: 1995/06/23
Message-ID: <azmoodehDAn94w.I9p_at_netcom.com>#1/1

Hi,
What is the best way to create a unique key for a table? We have a table where unique rows can be identified by concatenating four fields. This however makes SQL statements very long. For the sake of simplicity, is there a way to generate a unique key and perhaps add it to the table as a separate column?
Thank you in advance for your help.
Mickey

Senior Programmer/Analyst
InterActive Audiotext Services
Canoga Park, California Received on Fri Jun 23 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Ian Allen: "PL/SQL - system calls, random numbers and milliseconds"
Previous message: Marianne C. Brooks: "Oracle Book, Softwindows and PowerPC"
Next in thread: Peter Sylvester: "Re: A Good Way to Create a Unique Key?"
Reply: Chuck Gautney: "Re: A Good Way to Create a Unique Key?"
Reply: Shawn Lavin: "Re: A Good Way to Create a Unique Key?"
Reply: Peter Sylvester: "Re: A Good Way to Create a Unique Key?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message