Mimicking SQL Server identity column in Oracle

Wendelius

Rate me:

4.94/5 (5 votes)

8 Jan 2012CPOL6 min read

52K

312

This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.

OracleMimicIdentityScript.zip
- OracleMimicIdentityScript.txt
OracleMimicIdentity.zip
- OracleMimicIdentity.sln
- OracleMimicIdentity
  - App.xaml
  - App.xaml.cs
  - MainWindow.xaml
  - MainWindow.xaml.cs
  - OracleMimicIdentity.csproj
  - Properties


Microsoft Visual Studio Solution File, Format Version 11.00
# Visual C# Express 2010
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "OracleMimicIdentity", "OracleMimicIdentity\OracleMimicIdentity.csproj", "{FB5BEE99-A5EB-4022-BCB1-E8C47A283619}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|x86 = Debug|x86
		Release|x86 = Release|x86
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{FB5BEE99-A5EB-4022-BCB1-E8C47A283619}.Debug|x86.ActiveCfg = Debug|x86
		{FB5BEE99-A5EB-4022-BCB1-E8C47A283619}.Debug|x86.Build.0 = Debug|x86
		{FB5BEE99-A5EB-4022-BCB1-E8C47A283619}.Release|x86.ActiveCfg = Release|x86
		{FB5BEE99-A5EB-4022-BCB1-E8C47A283619}.Release|x86.Build.0 = Release|x86
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Wendelius

Architect

Europe

Biography provided

Mimicking SQL Server identity column in Oracle

License

Comments and Discussions