Home » RDBMS Server » Server Administration » Re: Select Row
Re: Select Row [message #370305] Thu, 19 August 1999 09:34
m a sivan
Messages: 34
Registered: July 1999
Member
yeah its better to have a sequence number in the table (auto generated) and find max(sequence) no. bcos that would be last addition. I feel this is the easiest way to do that or u can create a trigger like
create trigger <NM> on insert update <TEMPTABLE> set <SOMEPRIMKEYVALUE> = 'new val'

and then while retrieving retrieve data from this table first and then fetch...

Well I will think more if some easy solution exists..
But as Chris said dont rely on ROWID cause it is
Block.ROW.FIle format and Oracle doesnot guarantee anything regarding the sequence number... and believe me I have seen that max(rowid) is not the last row enetered always..
Previous Topic: Re: how to wrap packages?
Next Topic: How to initiate Escape Key
Goto Forum:
  


Current Time: Fri Mar 29 04:28:52 CDT 2024