RE: Sql Query

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Thu, 4 May 2006 12:36:34 -0700 (PDT)
Message-ID: <20060504193634.61051.qmail@web51309.mail.yahoo.com>

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:

    v\:* {behavior:url(#default#VML);}  o\:* {behavior:url(#default#VML);}  w\:* {behavior:url(#default#VML);}  .shape {behavior:url(#default#VML);}                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.                 

---

How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

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

Received on Thu May 04 2006 - 14:36:34 CDT