Home » RDBMS Server » Server Administration » system generated item
system generated item [message #183383] Thu, 20 July 2006 11:36 Go to next message
limbe
Messages: 20
Registered: July 2006
Location: Limbe, Cameroon
Junior Member
Hello!

What data type to used for an item to be system generated, this is i want a primary key generated by the system it self


Thanks

Report message to a moderator

Re: system generated item [message #183385 is a reply to message #183383] Thu, 20 July 2006 11:52 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps NUMBER datatype, which can be populated with a SEQUENCE in a BEFORE INSERT database trigger?

Report message to a moderator

Previous Topic: transferring database
Next Topic: data type
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:44:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.