There are n number of columns with n number of records . Example
Col1 Col2 Col3 -------- ------- ---------- 1 APPLE .. 2 BALL ... 3 CAT ... 4 DOG ... 5 ELEPHANT ... . . . Select col2 from tab_name; APPLE BALL CAT DOG ELEPHANT .. .. I want To display Above Records In The Following Format APPLE BALL CAT DOG ELEPHANT ... -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en