Select multiple rows into one rows not working in oracle form
Hello Oracle Master
I have select statement that working on TOAD but when it move into Oracle Form this is not working. My Database is 11G R2 and my form version is Forms [32 Bit] Version 10.1.2.0.2 (Production)
here the sql statement
select listagg (''''||username||'''',',') within group (order by username) username
into nama
from sri.sri_user_readonly;
the error is
Encountered the symbol GROUP
please help me oracle master
thx u
I have select statement that working on TOAD but when it move into Oracle Form this is not working. My Database is 11G R2 and my form version is Forms [32 Bit] Version 10.1.2.0.2 (Production)
here the sql statement
select listagg (''''||username||'''',',') within group (order by username) username
into nama
from sri.sri_user_readonly;
the error is
Encountered the symbol GROUP
please help me oracle master
thx u
0