Re: cursor
From: Antoine FERNIQUE <antoine.fernique_at_concours.ensam.fr>
Date: Thu, 02 Nov 2000 13:47:45 +0100
Message-ID: <3A016271.283F1CF8_at_concours.ensam.fr>
Date: Thu, 02 Nov 2000 13:47:45 +0100
Message-ID: <3A016271.283F1CF8_at_concours.ensam.fr>
depending on the size you can as well do
insert into iq_smt_tmp_assy_partnum_rd
(col1,col2,...)
select
myval1,myval2,...
from
a_table,
(
c1
) c1
where
condition = rs1.column_name and
to know if c1 take time just run it and do a timer
select to_char(sysdate,'DD-MM-YYYY HH24:MI SS') from dual
/
select count(*) from ( c1 )
/
select to_char(sysdate,'DD-MM-YYYY HH24:MI SS') from dual
/
then the insert may take time too if you've got a few constraints on them
-- Antoine FERNIQUEReceived on Thu Nov 02 2000 - 13:47:45 CET