Oracle: For which relational operators in where clause, index is not used?

Question

What are the advantage and disadvantages of using a select for update in a cursor Using the "for update clause" and then using useing "update... for current cursor" is a good way to make sure that no one else is changing the rows you are working with.

Answer 1

, like '% ...' is NOT functions, field +constant, field || ''