Select-Resultat in einer Spalte anzeigen

[Dejan Vu]

Schreib dir die Routine doch selbst:

Code:

SET TERM !!;
CREATE PROCEDURE PSLIST(ID INTEGER)
  RETURNS (CONCAT VARCHAR(2000))
AS
DECLARE VARIABLE name VARCHAR(255);
BEGIN
  CONCAT = '';
  FOR SELECT ZK_KLASSE 
        FROM V_ZUSATZ_KLASSE 
       WHERE ID_ZUSATZ = :ID 
       ORDER BY ZK_KLASSE 
  INTO :name 
  DO BEGIN
    CONCAT = CONCAT || coalesce(name,'');
  END
  SUSPEND;
END!!
SET TERM ;!!

Getippt und nicht getestet.