Hi again You guys rock and i am really thankful for all the help. As it is i am learning my way with sql pl/sql. Now i have run into another roadblock. Basically I have output from a query which produces a single column output in many rows. The query is Code (Text): SELECT REPLACE (attribute1, '_', '/') || ',' || attr_val FROM users_upload_new WHERE empid = '140' AND attr_val IS NOT NULL This produces the output Code (Text): COM/PRJ/STEEL,7 COM/PRJ/COMMON/ADM,7 COM/PRJ/COMMON/CMRCL,7 ----- ----- Now actually I want the output as Code (Text): COM/PRJ/STEEL,7,COM/PRJ/COMMON/ADM,7,COM/PRJ/COMMON/CMRCL,7 The comma separation is fine, Basically i want the multiple rows into a single row. Or you can say even multiple rows into a single row multiple column would do. i know I have to use SYS_CONNECT_BY_PATH but i can't seem to figure it out. It's ok if you don't give me full code, just some pointers would be great. Thanks for your time and help.