Jul 13, 2006 #1 PatelRam Programmer Joined Aug 20, 2003 Messages 87 Location US Hello, I have a table which contains following data. TableA: ColumnA ColumnB A1 C1 A1 C2 A2 C3 A2 C4 I need to build query which give me follwing output : A1 C1:C2 A2 C3:C4 Can someone help me out. Thanks, Ram
Hello, I have a table which contains following data. TableA: ColumnA ColumnB A1 C1 A1 C2 A2 C3 A2 C4 I need to build query which give me follwing output : A1 C1:C2 A2 C3:C4 Can someone help me out. Thanks, Ram
Jul 13, 2006 #2 feherke Programmer Joined Aug 5, 2002 Messages 9,541 Location RO Hi You need an aggregate function for that. Look at this example, is doing almost what you need, excepting the separator. http://www.adp-gmbh.ch/ora/sql/user_def_agg.html Feherke. http://rootshell.be/~feherke/ Upvote 0 Downvote
Hi You need an aggregate function for that. Look at this example, is doing almost what you need, excepting the separator. http://www.adp-gmbh.ch/ora/sql/user_def_agg.html Feherke. http://rootshell.be/~feherke/