We use "WITH UR" will retrieving the data "SELECT COL1 FROM TAB1 WITH UR". Uncommitted read. Can we also use it for Update statement ?
UPDATE COL1 FROM TAB1 WITH UR?
Please assist, Thanks in advance.
No Comments Posted for this Article.
Use user defined functions in SQL statements
Can we use user definbed functions in SQL statements, as we can use in built oracle function like date etc..? Yeah.Of course provided there is no dml in your function Thanks for reply...
Tuning Expensive SQL Statements
What are typical approaches to tune expensive SQL statements?Depending on the results of the analysis of an SQL statement the following optimizations can be...