--
--  Name: users_show.sql
--
--  Description: Users - Displays information about a user.  Use % for all users.
--
--  Compatability: 7.3 and above
--
--  Usage: @users_show.sql username
--

col temporary_tablespace format A20
col default_tablespace   format A20

select username,default_tablespace,temporary_tablespace 
from   dba_users
where username like upper('&&1')
;