SyntaxFix
Write A Post
Hire A Developer
Questions
Try:
select * from v$session where sid = SYS_CONTEXT('USERENV','SID');
You might also be interested in this AskTom post
After seing your comment, you can do:
SELECT * FROM global_name;