Month: April 2011

how to get all rows in a single row?

today one of my collague asked me to how to fetch all rows of a parameter table in a single row with oracle sql. so i wrote this. select * from (select * from (select rownum as rnum, c.* from ( select b.* from user.test b order by rowid) c) where rnum = 1), (select…

Read More