how to get current session info with select
hi,
how to get current session info with select. i need tis done inside a sql - I tried
select user from dual;and it works as single sql but I cannot use it in join.
like
select ..
from tabx, (select user from dual) u
..
Thanx in advance.
0