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@xxxxxxxxx>* wrote:
Search for stragg on http://asktom.oracle.com
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sanjay Mishra
*Sent:* Thursday, May 04, 2006 1:12 PM
*To:* oracle-l@xxxxxxxxxxxxx
*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>
