Re: Dimension table load - PLSQL question

Why not implement this in old fashioned way (don't you think that it
will work just fine), just do:

begin
  begin
    select pkey into p_key from t where t.descr1 = ( select descr1
from lkp_table1 where cd = p_cd1 ) and t.descr2 = ( select descr2 from
lkp_table2 where cd = p_cd2 ) ...
  exception when no_data_found then
    insert into t values () returning pkey into p_key;
  end;
  return p_key;
end;

Don't you think that this is very simple and easy to understand method
to implement required functionality?

In dependable of the method that you will use, you still has to select
data from all the lpk_tableX and then check table t, it doesn't meter
whether you use simple select or other Oracle functionality.

On 9/29/05, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:
> Yes, thanks, that could be done. Still have problem with key value return if
> record exists.
> rm


--
Best regards,
  Edgar Chupit
  callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l

Other related posts: