oracle - Deleting by ROWID -
i'd run query.
delete a006873.gc_clients rowid = '14519';
but error:
sql.sql: error (2,15): ora-01410: invalid rowid
i got in gc_clients
id number name 14519 0000017690 villavine
i don't realize what's wrong if i'm in correct id. i'm using sequence way , don't want delete where id = '14519'
.
rowid psuedocolumn returns address of row.
you can try if dont want delete id
delete a006873.gc_clients rowid in (select rowid a006873.gc_clients id = '14519');
Comments
Post a Comment