
set serveroutput on
set trimspool    on
set pagesize     999
set feedback     off
set verify       off
set recsep       off

alter session set nls_numeric_characters = ',.';

COLUMN USERNAME       FORMAT A30
COLUMN PROFILE       FORMAT A20
COLUMN DEFAULT_TABLESPACE       FORMAT A20
COLUMN TEMPORARY_TABLESPACE       FORMAT A20
COLUMN ACCOUNT_STATUS       FORMAT A20




SELECT USERNAME,USER_ID,ACCOUNT_STATUS,CREATED,PROFILE,TEMPORARY_TABLESPACE,DEFAULT_TABLESPACE
FROM DBA_USERS
WHERE USERNAME LIKE upper('&1')
ORDER BY USERNAME;

set feedback  on
