Posted By: Tex (Tex) on 'CZdatabases'
Title:     rekurze ?
Date:      Sat Mar 26 07:42:46 2005

Potrboval bych dat hodnoty z jednoho sloupce v tabulce do jednoho radku 
nejlepe selectem nebo funkci a nepouzit kutzor. Podarilo se mi to napsat v SQL 
serveru ale v oracle to tvrdosijne vraci null. Neresili jste to nekdo ?

SQL server:
-------------
declare @sml varchar(4000)
set @sml = ''
select @sml = @sml+some_column +',' from table


Oracle:
======
CREATE OR REPLACE FUNCTION o_test_group
RETURN VARCHAR2
IS
var_id VARCHAR2 (4000);
BEGIN
var_id := '?';

SELECT (var_id || NVL (cislo_smlouvy, ',') )
INTO var_id
FROM TABLE;

RETURN var_id;
END;
/


pak select o_test_group from dual 

vraci null pro jeden radek to vrati dobre.

dik.

Tex 

Search the boards