| 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..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
