title: Does a select SQL Statement on oracle lock the used table for update by other connections?
body: <p>Does a select SQL Statement on oracle lock the used table for update by other connections? is it depend if I'm doing the select inside a jta transaction or not ? how can I control this issue and prevent from read only SQL Statements to lock tables for editing ?</p>