Control for "Isolation level" at SELECT statement level

Hi folks.

Some RDBMS products support the following syntax format:

SELECT .... <whatever...> WITH {READCOMMITTED | REPEATABLEREAD | ... | SERIALIZABLE} The WITH clause provides the means for overriding the default isolation level (or the one
specified upon SET TRANSACTION) at a specific SELECT statement.

WITH clause is applicable for INSERT,UPDATE,DELETE as well.

Is there an equvalent to the "WITH" clause in Oracle's SQL?

Your answers will be appreciated.

Hillel. Received on Sun Aug 17 2003 - 07:55:54 CDT