select * from medicine_frequency;

AGE                  DRUG_DESCRIPTION               FREQ       MORNING    NOON       EVENING    BEFORE_BED OTHER        
-------------------- ------------------------------ ---------- ---------- ---------- ---------- ---------- -----------
26YYYY11MM29DD       Mobic 7.5 mg tablet            After Meal 1 Tablet              1 tablet                           
26YYYY11MM29DD       Cravit solutions 5 ml bottle              1 Drop     1 Drop     1 Drop     1 Drop      

function CF_1Formula return Char is
begin
Return 'Take '||:morning||' '||:noon||' '||:evening||' '||:before_bedtime||' '||:other;
end;

function cf_1_morning_before return char is
begin
  if :freq = 'before' then
     return ('Take ' || :morning ||' '|| :freq);
  else
     return (null);
  end if;
end;