Database Administration (MOSC)

MOSC Banner

how to get current session info with select

edited Jan 26, 2013 12:21AM in Database Administration (MOSC) 7 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center