Home » SQL & PL/SQL » SQL & PL/SQL » plz solve this query....
plz solve this query.... [message #245539] Mon, 18 June 2007 01:21 Go to next message
sunilcse1
Messages: 23
Registered: June 2007
Location: Bangalore
Junior Member
I have a table test like

no no1

1 a
1 b
1 c
2 d
2 e
2 f
3 g
3 h
3 i


I want to make another test1 table from the above like

no no1

1 abc
2 def
3 ghi


How could I do this...
Plz some one help me to solve this query...

Regards
Jinu

[Updated on: Mon, 18 June 2007 01:27]

Report message to a moderator

Re: plz solve this query.... [message #245544 is a reply to message #245539] Mon, 18 June 2007 01:52 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Jinu,
search the board for stragg/concat_all.

MHE
Previous Topic: Help with keys
Next Topic: RANGE type clause in analytic function
Goto Forum:
  


Current Time: Thu Dec 08 16:05:26 CST 2016

Total time taken to generate the page: 0.11534 seconds