how to add dbname column , when I query dba_users
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