Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

Get user name from all_users

SQL> SQL> select substr( username, 1, 1 )   2    from all_users au1   3   where rownum = 1; S - S 1 row selected.