On May 1, 7:55 pm, kes <abi...@[EMAIL PROTECTED]
> wrote:
> I'm working with Oracle 10g R2
>
> create table table1(
> table1_id number,
> csv1 varchar2(100),
> csv2 varchar2(100));
>
> insert into table1 values(1, 'a,b,c', 'w,x,y,z');
> insert into table1 values(2, 'a,b,c,d', 'x,y,z');
>
> select * from table1;
> "TABLE1_ID","CSV1","CSV2"
> "1","a,b,c","w,x,y,z"
> "2","a,b,c,d","x,y,z"
>
> I would like to see it like
> 1, a, b, c, , w, x, y, z
> 2, a, b, c, d, , x, y z
>
> Should I create a store procedure that will split the strings into
> different rows, then pivot them? Are there any good articles to point
> to a better way? Any suggestions will be welcomed.
>
> Alex
It looks like all you are asking for is to change the column separator
Check into the SET command if that is the case.
Ed
|
