Home » SQL & PL/SQL » SQL & PL/SQL » Time dependent primary key.
Time dependent primary key. [message #37569] Thu, 14 February 2002 09:32 Go to next message
Larbi
Messages: 1
Registered: February 2002
Junior Member
Hello all,
I appreciate if you could help on this:
I have two tables table1 (id,Time,...) and Table2 (...
Time). I am time profiling records to keep track of history.
Time is a part of primary key in table 1 and also
appearing as a foreign key in table 2. Since Time is changing each time I do an insert, the primary key is volatile, si I cannot update Table 1 without adjusting the Time in Table 2 and vice-versa. Anyone knows how I can avoid this ?
Have a nice day,
Larbi.
Re: Time dependent primary key. [message #37575 is a reply to message #37569] Thu, 14 February 2002 12:05 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
store it in local date variable and update tables using that value.

if you provide some sample data and structure, it will be easy to answer.
Previous Topic: Object access info.
Next Topic: SQLPlus trimming spaces in spool file
Goto Forum:
  


Current Time: Thu Sep 23 13:41:06 CDT 2021