Re: Sql Query

That's because you cannot return more than 4K in a varchar2, (or whatever you specified in your stragg script).

rgds

On 5/4/06, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
>
> Ken
>
> SQL> select stragg(table_name) from user_tables
> 2 /
> select stragg(table_name) from user_tables
> *
> ERROR at line 1:
> ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at "SYS.STRING_AGG_TYPE", line 17
> ORA-06512: at line 1
> It works for Group by Clauses like
> select table_name,stragg(index_name) from user_indexes group by
> table_name
>
> Regds
> Sanjay
>
>
> *Ken Naim <kennaim_at_gmail.com>* wrote:
>
> Search for stragg on http://asktom.oracle.com
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sanjay Mishra
> *Sent:* Thursday, May 04, 2006 1:12 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Sql Query
>
> Sql Gurus
>
> I need to create the sql script that can display all tables from
> user_tables in one line seperated by ",". Is there any straighforward SQL
> that can display the result in Horizontal instead of single table in each
> row.
>
> Regds
> Sanjay
> ------------------------------
> Yahoo! Mail goes everywhere you do. Get it on your phone<http://us.rd.yahoo.com/evt=31132/*http:/mobile.yahoo.com/services?promote=mail>
> .
>
>
> ------------------------------
> How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
> rates.
> <http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
>
>

--
http://www.freelists.org/webpage/oracle-l