Oracle Forms (MOSC)

MOSC Banner

Select multiple rows into one rows not working in oracle form

edited Jan 13, 2012 3:59AM in Oracle Forms (MOSC) 9 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center