tag:blogger.com,1999:blog-4677316190423110840.post-31625195125843843932007-06-05T09:03:00.000+02:002007-06-05T09:03:00.000+02:00Nice post... only downside with this approach is that if you have a large number of columns, you may end up with :<BR/><BR/>SQL> select table_name,<BR/> 2 ltrim(max(SYS_CONNECT_BY_PATH(column_name, ',')), ',') column_list<BR/> 3 from user_tab_columns<BR/> 4 where table_name = 'LARGE_TABLE'<BR/> 5 start with column_id = 1<BR/> 6 connect by table_name = prior table_name<BR/> 7 and column_id = prior column_id +1<BR/> 8 group by table_name<BR/> 9 /<BR/> from user_tab_columns<BR/> *<BR/>ERROR at line 3:<BR/>ORA-01489: result of string concatenation is too longAnonymousnoreply@blogger.com