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

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -