Get user name from all_users : User Password « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. User Password

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.








Related examples in the same category

1.create user chris identified by chris;
2.Change User password
3.make a password expire with the ALTER USER command
4.Alter user to change the password
5.Drop the user if it exists
6.Unassign Role from User
7.Remove user