Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Join v$session and v$access

SQL> SQL> SELECT a.sid, a.username, b.owner, b.object, b.type   2  FROM   v$session a, v$access b   3  WHERE  a.sid = b.sid   4  and    rownum < 2;        SID USERNAME ---------- ------------------------------ OWNER ---------------------------------------------------------------- OBJECT -------------------------------------------------------------------------------- TYPE ------------------------         44 SYS COL$ TABLE SQL>