Select aus String in DML

[mkinzler]

Zu Laufzeit generierte Statements kann man wie folgt absetzen:

SQL-Code:

execute block 
returns (erg <Typ>) 
as
  declare variable _id integer;
  declare variable _t char(31);
  declare variable _s char(31);
begin
  for select 
    id, tmpTabelle, tmpSpalte
  from
    <tabelley> into :_i, :_t, :_s
  do
  begin
    execute statement 'select ' || :s || ' from ' || :t || ' where  id = ' || :_id || ';' into :erg;
    suspend;
  end;
end;