|Subject||Re: [ib-support] FOR UPDATE clause|
> In Oracle, "select .. forConsidering that Oracle is not following SQL standard in such basic thing like JOIN ...
> update" lock the rows affecteds until commit/rollback. Browsing IB docs I
> read that "for update" is used only with "declare cursor .. " to especify
> subsequent "update .. where current of". Whell, the Oracle behavior (and MS
> SQL Server too) isn't the right (ANSI SQL) implementation?
> Could InterbaseInterbase does not lock rows with "select ... for update" statement.
> implentation is same like this but don't documented? If not (implemented)
> then I will suggest it.
SQL92 does not require it either. (iirc explanation from Diane Brown).
I would prefer to follow SQL standard rather than Oracle/Gates.