User Previliege Oracle PLSQL

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