Identity columns in Oracle?
From: Erik Foley <erikf_at_boris.dataworks.com>
Date: 1996/06/18
Message-ID: <4q50o0$i51_at_newshub.atmnet.net>#1/1
Date: 1996/06/18
Message-ID: <4q50o0$i51_at_newshub.atmnet.net>#1/1
I wonder if Oracle has some version of the Sybase 'Identity' column attribute? In Sybase, you can specify a key column as an Identity column. Then, when you perform an Insert to that table, if you don't supply a value for the Identity column, Sybase will find the greatest value in the table, and increment it for the new row. That may be an overly simplistic explanation, but it's reasonable accurate. So, does Oracle have anything similar?
Thanks,
Erik
erikf_at_boris.dataworks.com Received on Tue Jun 18 1996 - 00:00:00 CEST