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 |