insert into swma_temp_table
(m_serial,m_start,m_end,m_stat,m_product)
select '10-1D48H',to_date('2009-09-21', 'YYYY-MM-DD'),to_date('2011-07-31', 'YYYY-MM-DD'),'Active','694275P'
from dual 
where exists (select NULL from servers where host_serial='10-1D48H')
;
 -- 

insert into swma_temp_table
(m_serial,m_start,m_end,m_stat,m_product)
select '10-2D65H',to_date('2008-04-25', 'YYYY-MM-DD'),to_date('2011-07-31', 'YYYY-MM-DD'),'Active','694273H'
from dual 
where exists (select NULL from servers where host_serial='10-2D65H')
;
 -- 

insert into swma_temp_table
(m_serial,m_start,m_end,m_stat,m_product)
select '10-2D65H',to_date('2008-04-25', 'YYYY-MM-DD'),to_date('2011-07-31', 'YYYY-MM-DD'),'Active','694275O'
from dual 
where exists (select NULL from servers where host_serial='10-2D65H')
;