Query v$session table : session « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. session

Query v$session table

 
SQL>
SQL> SELECT username, sid, serial#, module, action
  2  FROM   v$session
  3  WHERE  row < 50;
WHERE  row < 50
       *
ERROR at line 3:
ORA-00936: missing expression


SQL>








Related examples in the same category

1.Query v$lock, v$session table
2.Create view on v$session