Home » SQL & PL/SQL » SQL & PL/SQL » Timestamp column as primary key.
icon9.gif  Timestamp column as primary key. [message #197238] Tue, 10 October 2006 13:16 Go to next message
Messages: 115
Registered: January 2003
Senior Member
Hi all,

I have a table in oracle that has two columns. itemcode & comment_datetime. These two columns make up primary keys.
Itemcode char(13) & comment_datetime is a timestamp column.
In oracle i can not make a timestamp column as a primary key column. Is there any way around to solve this problem??

Re: Timestamp column as primary key. [message #197240 is a reply to message #197238] Tue, 10 October 2006 13:28 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Do you instead mean TIMESTAMP WITH TIME ZONE? That is the datatype that cannot appear in a PK constraint.

TIMESTAMP can appear in a PK constraint.
Next Topic: Return XML from the database
Goto Forum:

Current Time: Sun Oct 23 11:35:55 CDT 2016

Total time taken to generate the page: 0.06587 seconds