Jul 13, 2006 #1 PatelRam Programmer Aug 20, 2003 87 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 Aug 5, 2002 9,540 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/