45 lines
1.0 KiB
SQL
45 lines
1.0 KiB
SQL
set linesize 250
|
|
set verify off
|
|
|
|
set feedback off
|
|
column inputpar01 new_value 1 noprint
|
|
select 1 inputpar01 from dual where 1=2;
|
|
set feedback 6
|
|
|
|
column username format a30
|
|
column created format a10
|
|
column lock_date format a10
|
|
column expiry_date format a11
|
|
column profile format a25
|
|
column account_status format a25
|
|
column default_tablespace format a20
|
|
column temporary_tablespace format a20
|
|
column authentication_type format a10 heading "PWD TYPE"
|
|
column last_login format a22 heading "LAST LOGIN"
|
|
column oracle_maintained format a3 heading "DEF"
|
|
column common format a3 heading "COM"
|
|
|
|
|
|
select
|
|
username,
|
|
to_char(created, 'DD/MM/YYYY') created,
|
|
profile,
|
|
account_status,
|
|
to_char(lock_date, 'DD/MM/YYYY') lock_date,
|
|
to_char(expiry_date, 'DD/MM/YYYY') expiry_date,
|
|
to_char(last_login, 'DD/MM/YYYY HH24:MI TZH') last_login ,
|
|
default_tablespace,
|
|
temporary_tablespace,
|
|
authentication_type,
|
|
common,
|
|
oracle_maintained
|
|
from
|
|
dba_users
|
|
where
|
|
username like nvl('&1', '%')
|
|
order by
|
|
username
|
|
;
|
|
|
|
undef 1
|