Home » RDBMS Server » Server Administration » Unique field
Unique field [message #54697] Thu, 28 November 2002 07:16 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hello All,

Can somoeone please help me out with this.

In one of my Oracle tables, I need to add a column that will hold a unique value for each row that gets created. I need this column for doing data validatation for a integration requirement.

How can this be done ? Would it be a sequential counter or something else and how can i implement it, please let me know about it.

Thanks!

Report message to a moderator

Re: Unique field [message #54698 is a reply to message #54697] Thu, 28 November 2002 07:56 Go to previous message
psmyth
Messages: 81
Registered: October 2002
Member
use a sequence or a trigger - a sequence is probably simpler and more relevant to your needs.

Check the oracle documentation for the details ;-)

http://technet.oracle.com/docs/content.html

Report message to a moderator

Previous Topic: Oracle Database Configuration Assistant
Next Topic: kernel parameters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:49:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.