help! concat 2 row string [message #374072] |
Wed, 23 May 2001 20:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ssai
Messages: 5 Registered: May 2001
|
Junior Member |
|
|
hi..i have an output like this..
MODEL
--------------------
Commodore
VS
Corolla
AE94
and how to get this output:
MODEL
--------------------
Commodore VS
Corolla AE94
anybody help.. thanx
|
|
|
|
|
Re: help! concat 2 row string [message #374079 is a reply to message #374076] |
Thu, 24 May 2001 00:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ssai
Messages: 5 Registered: May 2001
|
Junior Member |
|
|
thanx,
but the string (i.e.) is like this
Commodore
VS
in the table. for your information, the column size is varchar(20). how to shift the VS to the next Commodore?, because set wrap is working but the vs is omitted..
thanx again..
|
|
|
Re: help! concat 2 row string [message #374080 is a reply to message #374076] |
Thu, 24 May 2001 00:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ssai
Messages: 5 Registered: May 2001
|
Junior Member |
|
|
thanx,
but the string (i.e.) is like this
Commodore
VS
in the table. for your information, the column size is varchar(20). how to shift the VS to the next Commodore?, because set wrap is working but the vs is omitted..
thanx again..
|
|
|
Re: help! concat 2 row string [message #374081 is a reply to message #374076] |
Thu, 24 May 2001 00:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ssai
Messages: 5 Registered: May 2001
|
Junior Member |
|
|
thanx,
but the string (i.e.) is like this
Commodore
VS
in the table. for your information, the column size is varchar(20). how to shift the VS to the next Commodore?, because set wrap is working but the vs is omitted..
thanx again..
|
|
|
Re: help! concat 2 row string [message #374082 is a reply to message #374076] |
Thu, 24 May 2001 00:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ssai
Messages: 5 Registered: May 2001
|
Junior Member |
|
|
thanx,
but the string (i.e.) is like this
Commodore
VS
in the table. for your information, the column size is varchar(20). how to shift the VS to the next Commodore?, because set wrap is working but the vs is omitted..
thanx again..
|
|
|