Take command-line parameter or prompt if no parameter given: col u_schema new_value u_schema noprintprompt "Please enter the schema to check on (wildcards ok): "set feed off term off echo offselect upper('&1') u_schema from dual;set feed on term onselect username, default_tablespace, temporary_tablespacefrom dba_userswhere username like '&&u_schema';undef 1 |