Suurogate key generation in a database
Posted: Mon Dec 13, 2010 6:51 am
Hi Folks
I want to generate a surrogatekey directly in a table i mean neither using a flatfile nor using a database sequence.How is it possible and which properties i have to fill with what? say my colnume for surrogatekey is ID_NUMBER Number(25,0) PK and table name is TABLENAME.
The efforts will be appreciated.
I want to generate a surrogatekey directly in a table i mean neither using a flatfile nor using a database sequence.How is it possible and which properties i have to fill with what? say my colnume for surrogatekey is ID_NUMBER Number(25,0) PK and table name is TABLENAME.
The efforts will be appreciated.