oracle – dForge.net

Development

Oracle SELECT … WHERE IN (:bind_variable_array)

By Ron S. November 5, 2012 November 5, 2012 0

As we all know, one of the best ways to prevent SQL injection attacks in PHP (or any server side language for that matter) is to use parameterized queries. But how do you parameterize a WHERE … IN clause? One way is to use a user-defined function. The below example …

Reference

Show Oracle Locks

By Ron S. August 16, 2012 August 16, 2012 0

If you’re having issues with locks in Oracle, here’s a way to show what sessions have locks on which objects. select s.osuser “O/S-User”, s.username “Ora-User”, s.sid “Session-ID”, s.serial# “Serial”, s.process “Process-ID”, s.status “Status”, l.name “Obj Locked”, l.mode_held “Lock Mode”, count(*) from v$session s, dba_dml_locks l, v$process p where l.session_id = …