Case und While in einer Stored Procedure nutzen

Februar 21, 2019 - Lesezeit: ~1 Minute

execute block
returns
(txt varchar(10))
as
declare variable i int=1;
begin
  while (i<10) do begin
    txt=case i
       when 1 then 'Eins'
       when 2 then 'Zwei'
       when 3 then 'Drei'
       else '>3'
    end;
    i=i+1;
    suspend;
  end
end

Tags: Firebird