Unnamed

create or replace procedure SP_H02_09 is
  v_som number default 0;
  v_aantal pls_integer default 0;
  v_procent number default 0;
  v_bedrag number default 0;
BEGIN
  select count(*)
  into v_aantal
  from user_tables
  WHERE table_name = 'LOG_TABLE';
  if v_aantal = 0
    then
      execute immediate 'create table LOG_TABLE('
      || ' getal number'
      || ', tekst varchar2(200)'
      || ', datum date)';
  end if;
END;