
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 A25
COLUMN USER_ID       FORMAT 9999
COLUMN PROFILE       FORMAT A20
COLUMN DEFAULT_TABLESPACE       FORMAT A25
COLUMN TEMP       FORMAT A20
COLUMN INITIAL_RSRC_CONSUMER_GROUP       FORMAT A22
COLUMN ACC_STATUS       FORMAT A15




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

set feedback  on
