SELECT a.osuser,
a.sid,
b.os_user_name,
b.oracle_username,
b.session_id,
c.object_name,
c.object_type
FROM v$session a, v$locked_object b, dba_objects c
WHERE a.sid = b.session_id
AND b.object_id = c.object_id
AND c.object_name = UPPER ('TABLE_NAME');
Related Posts
JSON_MERGEPATCH function is very useful to update JSON nodes in JSON documents. We can simply pass the JSON required JSON patch to merge with the existing JSON document using the JSON_MERGEPATCH function, it can add or update the JSON node... Read more
How to reorder ORACLE table columns? Sample table CREATE TABLE test_column ( id NUMBER, name VARCHAR2 (200), created_by VARCHAR2 (50) ); Add a column ALTER TABLE TEST_COLUMN ADD EMAIL VARCHAR2(50); Column Order will be Reorder Email next to NAME. ALTER... Read more
Referred from Oracle Standard Document Data retrievable / parsing using JSON_TABLE Read more
PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or... Read more
Solution 1 : OR Solution 2 : Solution 3 : Read more
How to get Distinct/Unique record without using DISTINCT SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : Solution 4 : Solution 5 : Solution 6 : Solution 7 : Solution 8 : Solution 9 : Solution 10 : Read more
APEX_LANG.MESSAGE API is a great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very useful to translate the messages or string returned from PL/SQL stored... Read more
How to save table images to oracle directory? Files from table to Oracle directory How to Send all files in ZIP? You might Like: Read more
Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments... Read more
How to delete duplicate record From table using SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more