Repo 5 curdb.sql

From DB Optimizer
Jump to: navigation, search
-- (c) Kyle Hailey 2007
select host from sash_targets;
column f_host new_value v_host
column f_dbid new_value v_dbid;
select '&host' f_host  from dual;
select dbid f_dbid from sash_targets where host='&v_host';
delete from sash_target;
insert into sash_target values (&v_dbid);
commit;