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
jinga
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??

Ananthi
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.
Previous Topic: SQL PROBLEM !!! PLEASE HELP
Next Topic: Return XML from the database
Goto Forum:
  


Current Time: Thu Dec 08 18:46:53 CST 2016

Total time taken to generate the page: 0.08271 seconds