SELECT client_identifier,
module,
action,
s.*
FROM v$session s
WHERE sid IN (SELECT session_id
FROM dba_dml_locks
WHERE owner = 'AR' AND name = 'AR_ADJUSTMENTS_ALL')
A Language is not worth knowing unless it teaches you to think differently.
SELECT client_identifier,
module,
action,
s.*
FROM v$session s
WHERE sid IN (SELECT session_id
FROM dba_dml_locks
WHERE owner = 'AR' AND name = 'AR_ADJUSTMENTS_ALL')
SELECT client_identifier, module, action, s.* FROM v$session s WHERE sid IN (SELECT session_id FRO...