Database Administration (MOSC)

MOSC Banner

how to add dbname column , when I query dba_users

edited Sep 16, 2019 11:11AM in Database Administration (MOSC) 10 commentsAnswered ✓

COL USERNAME FORM A20

COL PROFILE FORM A30

SELECT USERNAME, PROFILE FROM DBA_USERS WHERE USERNAME IN ('USER1','USER2');

I am looking to get a dbname, but seems there is no way..

I am looking for below result

DB_NAME, USERNAME, PROFILE

and also

can we result as below to

DB_NAME, USER1, PROFILE, USER2, PROFILE ...............................

Thanks

Srihari

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