>>However, I'm of the opinion that an ounce of prevention is really worth pounds of cure. If I'm pulling a cursor that is not going to be updated I will not add rewrite. select * from table nofilter gives me a readonly cursor. select * from table nofilter readwrite gives me a non-readonly cursor.
>>
>>If I should happen to issue a replace command against the readonly cursor, I've saved my sanity because the data could not affected.
>
>The READWRITE is sufficien by itself (it includes NOFILTER).
select * from mytable readwrite
No because it means all cursors will be readwrite, when only some need to be readwrite.