User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. 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.