title: Aggregate String Concatenation in Oracle 10g
body: <p>I'm using Oracle 10 g, I have a scenario similar to this:</p>
  
  <p>No  Name<br/>
  --  -----<br/>
  1   Rony<br/>
  1   James<br/>
  1   Aby<br/>
  2   Sam<br/>
  2   Willy<br/>
  3   Mike<br/></p>
  
  <p>I need to aggregate and concatenate the strings (with a single space in between), in a way to get the results:<br/></p>
  
  <p>No  Name<br/>
  --  -----<br/>
  1   Rony James Aby<br/>
  2   Sam Willy<br/>
  3   Mike<br/></p>
  
  <p>I'm using Oracle 10g and have to implement this using SQL and not PL/SQL. Is there a way out?</p>