Re: ORA-00942: table or view does not exist for v$session.

Hi Eugene,

while i am running "SELECT COUNT(*) cnt,status FROM v$session GROUP BY status" it is working fine, fetching the records

but same thing iam using in a procedure like below  FOR i IN

    ( SELECT COUNT(*) cnt,status FROM SYS.v$session GROUP BY status     )
    LOOP
  ---
    END but here i am getting the Same error Table does not Exist

can you please reply on this plese

and is there any possiblities to use this query resultset in my procedure? Received on Fri Feb 12 2016 - 10:57:32 CET