set echo off

set verify off

column 1 new_value 1 noprint

column 2 new_value 2 noprint

column 3 new_value 3 noprint

select null as "1", null as "2" , null as "3" from dual where 1=0;

column sep new_value sep noprint

select '--------------------------------------------------------------' as sep from dual;

spool params.sql.tmp

column ut3_owner new_value ut3_owner noprint

column ut3_password new_value ut3_password noprint

column ut3_tablespace new_value ut3_tablespace noprint

select coalesce('&&1','UT3') ut3_owner,

coalesce('&&2','XNtxj8eEgA6X6b6f') ut3_password,

coalesce('&&3','users') ut3_tablespace from dual;

@@create_utplsql_owner.sql &&ut3_owner &&ut3_password &&ut3_tablespace

@@install.sql &&ut3_owner

@@create_synonyms_and_grants_for_public.sql &&ut3_owner

exit