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.