Need Query/Procedure to concatenate multiple(n) rows into one row for a particular record dynamically

Database

Need Query/Procedure to concatenate multiple(n) rows into one row for a particular record dynamically

Hi,

I am facing a problem with concatinating multiple rows in order and storing in to a target table for particular records.

Pls help me. I need a procedure or any good thing. Below is my input sample data 





EMP_SOURCE
eid  name line_num Addr
300 satya 1 gandhi na
300 satya 2 gar near hot
300 satya 3 el baristha h
300 satya 4 yderabad
301 raja 1 ramnthapur hy
301 raja 2 derabad
302 shree 1 gachibowli ne
302 shee 2 w street hyde
302 shree 3 rabad

And Required Output is





EMP_TARGET
eid  name Addr
300 satya gandhi nagar near hotel baristha hyderabad
301 raja ramanthapur hyderabad
302 shree gachibowli new street hyderabad

*I have millions of records with distinct EID's in Source.

I tried Recursive function but it's using more spool and also its not concatinating in order(Data should be cancatinated with the respect of Line_Num). So Iam thinking that recursive is not a good thing.

Pls share me If you have any Idea.

Thanks,

Sathya.