Oracle‎ > ‎SQL‎ > ‎


Take command-line parameter or prompt if no parameter given:

col u_schema new_value u_schema noprint

prompt "Please enter the schema to check on (wildcards ok): "
set feed off term off echo off
select upper('&1') u_schema from dual;
set feed on term on

select username, default_tablespace, temporary_tablespace
from dba_users
where username like '&&u_schema';

undef 1
Subpages (2): DDL Generation Sum Reports