RE: Sql Query
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <smishra_97@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 May 2006 15:33:07 -0500
So just nest it with a group by either by schema or just create a constant.
Select stragf(table_name) from
(Select table_name, 'a' cnstnt from user_tables)
Group by cnstnt
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sanjay Mishra
Sent: Thursday, May 04, 2006 2:37 PM
To: kennaim@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Sql Query
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
<http://us.rd.yahoo.com/evt=31132/*http:/mobile.yahoo.com/services?promote=m
ail> it on your phone.
_____
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone
<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http:/us.rd.yahoo.com/evt
=39663/*http:/voice.yahoo.com> call rates.
Other related posts:
