| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Removing dublicate records in table and hostarray
Brian Rasmusson <br_at_belle.dk> wrote (in
<354428E6.EE1BFEDE_at_belle.dk>)...
[snip]
| Yes, but those cannot be deleted from rowid.. Thats the only catch i
| have found so far ;-)
|
Hello Brian,
When you retrieve the Rowids you my need to use the 'RowidToChar'
function and use the 'CharToRowid' function when deleting.
I am puzzled as to why you cannot delete using the Rowid as a key (it
should work fine). What about updating, does that work? What version
of Oracle are using?
If you really cannot delete / update rows using Rowid then if you have a primary key on the Transaction table then delete / update / whatever using that. Otherwise i suggest you add a sequence column to your transaction table and make that a primary key.
graham Received on Mon Apr 27 1998 - 02:30:51 CDT
 |
 |